How to Group By, then count and export the result as groupby

[Anonymous]

Hello everyone

I just want to implement a simple tasks of:

- Load data from CSV list

- Read each file

- Transform a data field

- Do group by and count 

So that I implement the workflow as below screenshot.

My error happen at tAgrregationRow with message : the operation 'count' for the output column can't be processed because of incompatible input and/or output types.

Please tell me what is wrong with them?

Full workflow

tMap details

tAgrregationRow details

[Anonymous · Accepted solution]

Hi
You don't configure the component settings correctly.
You are trying to count the number of records for each group, so you need to define one column with int type in the output schema of tAggregateRow. For example, define two columns:
CoreSet string type
counts int type // this column will be used for operation.

Regards
Shong