One Star lkv
One Star

Perform Distinct column and count * function

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 ?
3 REPLIES
One Star lkv
One Star

Re: Perform Distinct column and count * function

How do i get his output then?
One Star lkv
One Star

Re: Perform Distinct column and count * function

Any one could help me with this ?
Community Manager

Re: Perform Distinct column and count * function

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
----------------------------------------------------------
Talend | Data Agility for Modern Business