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 audi357
I'm afraid i cannot reproduce your scenario. Maybe you need change the filter rows with other conditon such as 'dose not equal'.
Regards,
Cherie