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
v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi audi357

 

You may use 'Merge Queries' in query editor to get the table. Update the sample file for your reference. Please let me know if it helps you.

 

Regards,

Cherie

  • 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
      Microsoft 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?