I’m facing an issue which took me the full day reading and researching, so i thought here is my last resort.
Basically, I’m trying to create subtotals out of a datatable, so i’m using BalaRava activity for that
i get the following error (Group By Aggregation: Syntax error in aggregate argument: Expecting a single column argument with possible ‘Child’ qualifier.)
I’ve used a change column data type activity to change the column type to Int and Double to try different types but still face the same issue.
Note: upon researching seems like my problem is that the data column even after converting the data type to a certain type still contains decimals.
Hope that you can help me out, folks.
Thanks in advance.