#1 2009-08-07 20:20:30

venkatk
New member
Registered: 2009-07-17
Posts: 5

Distinct records

Tags: [Distinct, group]

Hi all,
Can some one please let me know how to get the distinct records from the incoming.

Here is my source data,

1    Q1    CY1900        01-JAN-00    31-MAR-00    01-JAN-99    31-MAR-99    01-JAN-01    31-MAR-01   
1    Q1    CY1900        01-JAN-00    31-MAR-00    01-JAN-99    31-MAR-99    01-JAN-01    31-MAR-01   
1    Q1    CY1900        01-JAN-00    31-MAR-00    01-JAN-99    31-MAR-99    01-JAN-01    31-MAR-01   
1    Q1    CY1900        01-JAN-00    31-MAR-00    01-JAN-99    31-MAR-99    01-JAN-01    31-MAR-01   
1    Q1    CY1900        01-JAN-00    31-MAR-00    01-JAN-99    31-MAR-99    01-JAN-01    31-MAR-01   
1    Q1    CY1900        01-JAN-00    31-MAR-00    01-JAN-99    31-MAR-99    01-JAN-01    31-MAR-01   

I need to pull only one record from the above source data,
1    Q1    CY1900        01-JAN-00    31-MAR-00    01-JAN-99    31-MAR-99    01-JAN-01    31-MAR-01

Appreciate your help on this.

Thank you,
-Venkat

Offline

#2 2009-08-10 03:43:15

shong
Talend team
Registered: 2007-08-29
Posts: 10351
Website

Re: Distinct records

Hello Venkat
Using a tAggregateRow and group by all the fields, see my screenshot.

Best regards

          shong


Uploaded Images


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

Board footer

Powered by FluxBB