topic Re: Perform Distinct column and count * function in Talend Studio

Perform Distinct column and count * function

Anonymous — Fri, 18 Sep 2015 05:07:04 GMT

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 ?

Re: Perform Distinct column and count * function

Anonymous — Fri, 18 Sep 2015 21:59:55 GMT

How do i get his output then?

Re: Perform Distinct column and count * function

Anonymous — Wed, 23 Sep 2015 20:53:16 GMT

Any one could help me with this ?

Re: Perform Distinct column and count * function

Anonymous — Thu, 24 Sep 2015 04:24:57 GMT

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