I have a GroupBy node which takes input from an Excel Reader.
In the aggregation setting I choose a column “Delta Start Absolute” with data type Double.
Using data set A, the workflow works fine.
But when using data set B, the GroupBy node throws an error:
Execute failed: Runtime class of object “6475505.0” (index 1) in row “Row0” is Number (double) and does not comply with its supposed superclass Number (integer)
Apparently, ExcelReader automatically classify “Delta Start Absolute” in data set B as Integer, therefore causing error in GroupBy nodes because of data type mismatch.
I see your point. Seems there are two things (that poop on my mind) you can do depending on your case/data set. One is Type Based Aggregation in GroupBy node in case you have only one numeric column in your data set. There you choose Double type with your aggregation method and Type matching Include sub-types.
This will perform aggregation on every double, long and int column. As said this makes sense only if you have one numeric column in your data set which obviously might not be the case so second approach is to use Math Formula node after Excel Reader to always make sure your column of interest is Double. Just don’t check convert to Int
