Forum Discussion

audi357's avatar
audi357
Frequent Visitor
7 years ago

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?   ...
Need Help
audi357's avatar
audi357
Frequent Visitor
7 years ago

This solution does work! However I have a small issues I have multiple "NC_SEQ" it can be up to 50 (1-50), This solution accounts for up to two (1-2) "NC_SEQ". Is there and easy adjustment for this query?

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi audi357

 

Add some rows and steps for sample data. You may check if it matches your request. Here is the sample file.

 

Regards,

Cherie

  • audi357's avatar
    audi357
    Frequent Visitor
    7 years ago

    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?  

    • v-cherch-msft's avatar
      v-cherch-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      7 years ago

      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 

       

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      7 years ago

      Hi,

       

      Share the link from where i can download your PBI file.