Data Filter Expression in ADF

Question

I am trying to filter data in Azure Data Flow.
However, I do not know how to do this.
What I want to do is to extract only the records with the largest value in the "seq_no" column among those with duplicate IDs.
I just don't know what function to use to achieve this.
I await your answer.
Any answer would be appreciated.
Sorry for my bad English, I am Japanese.
Thanks for reading.

Answer 1

Hey
you can use Aggregate transform in dataflow and Group by your ID column and then take the max of that column.
Similar to partition in SQL.