Perform Distinct column and count * function

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 ?
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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog