Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This is my requirement
I have input file with below content.
NOTE : It can be either excel file or DB as input
I need the output as
When i use the below highlighted component
fileInput-->AggregateRow i get
Tom@abc.com
John@abc.com
But after that i am unable to get the total count. Can anyone help me on this?
Actually AggregateRow is little confusing for me.
The document showing both the "InputColumn" and the "Output column" are different. But if you in my case i have 4 columns as input from a excel and which will only be available for both input and output column in the Aggregate component. Does the document referring one of the Input column should be selected as Output column ?
I have input file with below content.
NOTE : It can be either excel file or DB as input
I need the output as
When i use the below highlighted component
fileInput-->AggregateRow i get
Tom@abc.com
John@abc.com
But after that i am unable to get the total count. Can anyone help me on this?
Actually AggregateRow is little confusing for me.
The document showing both the "InputColumn" and the "Output column" are different. But if you in my case i have 4 columns as input from a excel and which will only be available for both input and output column in the Aggregate component. Does the document referring one of the Input column should be selected as Output column ?
How do i get his output then?
Hi
In the output schema of tAggregateRow, you should define two columns: user and totalTickets. Set user column as a group element, see the mapping as shown below:
Hope this helps you.
Best regards
Shong
In the output schema of tAggregateRow, you should define two columns: user and totalTickets. Set user column as a group element, see the mapping as shown below:
Hope this helps you.
Best regards
Shong