Is there a way, in analyzer or ETL, where we can only display one row for each unique value of a column corresponding to a key column? For example, I would want this:
ID Num
1 4
1 4
1 5
2 4
2 5
2 6
3 6
3 7
3 7
to become this:
ID Num
1 4
1 5
2 4
2 5
2 6
3 6
3 7