You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
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
Hello Venkat
Using a tAggregateRow and group by all the fields, see my screenshot.
Best regards
shong
Offline
Pages: 1