Skip to Content
0

Filtering unique records from source in SAP HCI DS

Feb 16 at 01:06 PM

84

avatar image
Former Member

Here i have duplicates for 80009898 and 81999898. we need unique records based on GDATU.

dupcapture.jpg (106.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Mar 05 at 06:59 PM
0

you can use a aggregate transform to do group by or GEN_ROW_NUM_BY_GROUP function to filter duplicate records in the next transform

Share
10 |10000 characters needed characters left characters exceeded