Group By Aggregation activity with Datatable issue

Hi All,

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.

To get help you should provide sample data of your datatable and grouping conditions.

Cheers

1 Like

Facing same problem: RemoteException wrapping System.Data.SyntaxErrorException: Syntax error in aggregate argument: Expecting a single column argument with possible ‘Child’ qualifier.

Please help