Forum Discussion
Pivot
I have a table it has a key field that has duplicate numbers which I need to piviot each key field into 1 row. I have tried pivot and unpivot but nothing is seeming to work, can you assist? ...
The first sample only 1 unique "key" which is correct. This sample would not give the desired results.
In the first sample I added multiple steps "Merge3 (nc_seq = 3), merge4 (nc_seq=4), merge5 (nc_seq=5)" then Merged them all together adding one at a time. This does work. However I will need to create a total of 50 steps. Is there a better solution?
Hi,
Share the link from where i can download your PBI file.