Any advise on how to de dedupe each column for duplicate values
OUTPUT
There is a way to do it with Gather, Dedupe, Spread and Slide.
But there is also a much simpler way with just Unfill and Slide.
Prashant.transform (5.5 KB)
You will need the latest snapshot for Slide.
Ps/ Please donât forget to mark posts like this as âQuestionâ.
From my point of view the âcomplexâ solution is required. The simple one with Unfill wouldnât work in case there is a sequence in one column like âX, X, Y, Xâ. The complex one is more robust.
You can ensure the original columns order by extracting just the headers (with filter) and adding a Stack transaction âŚ
Prashant_2.transform (6.5 KB)