Deduplicator Concept

Hellos,

I am confused with how DeDupe works in Advance ETL. I have a file with 3 columns with 110 rows , 43 duplicate removes , 67 unique items  
--> ID | Our Ref | Items  
Dedupe is to be removed with combination of Our Ref+Items

When I select DeDuplicator Object , I check two items OurRef+Items but then in output ID column is removed , how do I bring the column back ? I need to do a join?

See My Loom Video for Explanation
See my File for Input Data
See my file for expected output

 

Can you attache your transformation please

Please see transformation attached as requested.

Please stop placing links to the files on your own web site

Hi.

I can see that you have duplicated ids.



I assume that you want to keep the first one

In this case grouper object is a more suitable option.

www.etl-tools.com/wiki/advanced-etl-proc...orming-data/grouper/

Peter.Jonson wrote:

Hi.

I can see that you have duplicated ids.

I assume that you want to keep the first one

In this case grouper object is a more suitable option.

www.etl-tools.com/wiki/advanced-etl-proc...orming-data/grouper/

Grouper Works !! Thank you