Pivot

[audi357]

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?

[v-cherch-msft]

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]

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]

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]

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?  

[Ashish_Mathur]

Hi,

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

[v-cherch-msft]

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