Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Pivot and Unpivoting columns in table

Hi Team,   I have table in Tranform data :  Id Attribute Value 11 Premium 600 11 Percentage 9% 11 Tax 55.8   and I wanted to show it like : Id Premuim Percen...
Need Help
Show and Tell
  • JIGAR's avatar
    JIGAR
    5 years ago

    Anonymous 

     

    Select the Attribute column and do a Pivot on it. See the screenshot below to see what you have to set in Values column and aggregate function

     

     

    This is how the result will look like.

     

     

    Thanks

JIGAR's avatar
JIGAR
Icon for Resolver IV rankResolver IV
5 years ago

Anonymous 

 

Select the Attribute column and do a Pivot on it. See the screenshot below to see what you have to set in Values column and aggregate function

 

 

This is how the result will look like.

 

 

Thanks