Forum Discussion
GroupBy DataFormat.Error
I'm trying to do a groupby operation, and am getting the following error: That was never supposed to be a number, in the previous step I specifically converted it to text: What gives?...
I had to change the "Current Item Number" column to text at the initial import, not in a later step (but still before the groupby operation). I don't know why.
SacheeTh
lbendlin
The [Sum of Quantity Transaction] column isn't the column with the error. (I did a remove errors on the column, just in case).
The item it is referring to '342770207122E' is in the "Current Item Number" column, which should not be numbers, it should be strings. That 'E' is not a mistake, it is in the part number. So I can't remove it from the dataset, and can't covert that column to numbers. It shouldn't have to be numbers either, the same way "Branch Plant" isn't numbers. No math is being done there.