Group By Aggregation activity with Datatable issue

Help Studio
, , , ,
1

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.

2

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

Cheers

1 Like
3

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

Please help

4

Were you able to solve this problem?

5

I figured it out: the name of your column is likely two words. Fix the error by changing the column name into a single string. For example: “Total_spending” instead of “total spending”.

1 Like