I have a DT that looks like this:
Col1 Col 2
I essentially need to consolidate unnecessary rows and count the rows I do consolidate.
With the above example, I need to invoke Sample1.xaml once for each unique value in Col1 (in this case, invoke for Value1 and for Value2).
Then, I need to invoke Sample2.xaml for each unique pairing of Col1 and Col2 (in this case, invoke for Value1:ValueA *2, for Value1:ValueB *1, and for Value2:ValueA *1) and pass the number of occurrences of each pairing (the asterisk number).
Hopefully that’s clear enough. Any help is greatly appreciated!