Magic ETL | Remove Duplicates Old Raw

Miguel Member

December 2022 in Magic ETL

Hi,

Assume my data like that

I want to become

If I use Remove Duplicates in ETL, it only keep the old row.

What should I do now ?

Many thanks

Tagged:

• Filters
• Magic ETL

0

Answers

• 

  GrantSmith Coach

  December 2022

  You can use a group by tile to select the MAX Date grouping on your ID then do an inner join where the Date and ID match to get the most recent records in your ETL.

  **Was this post helpful? Click Agree or Like below**
  **Did this solve your problem? Accept it as a solution!**

  1

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.

Sign In