Forum Discussion

Jos13's avatar
Jos13
Helper III
6 years ago
Solved

Unpivot

Hi Team,

I have a data with the following structure.

I unpivoted the columns as follows,

then I split the Attribute column by number of characters

Next I did pivoting the Attribute 1 column with Value column which gave me the following table.

The expected table should only contain 2 rows. Can anyone please explain what did go wrong ? 

 

Thanks,

Jos

Data Protection
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi, Jos13 

    Can you show me  the  result you want?

    If this is the expected result your want ,you can check if the following sample file helps.

    pbix attached

     

    Best Regards,
    Community Support Team _ Eason

2 Replies