Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Split column into two columns

Hello all,   Im trying to split the data in a column "Value" into two collumns: 1. Value - will contains numbers only 2. Type - will contains all the text (Solid, Liquid, etc) in line with ...
Need Help
  • mlsx4's avatar
    mlsx4
    2 years ago

    Hi Anonymous 

     

    1. Trim Attribute column (just to avoid extra "space" characters)
    2. Create a conditional column: if attribute = "Excalibur" then return "Solid" and so on...
    3. Remove first 4 rows
JoeBarry's avatar
JoeBarry
Solution Sage
2 years ago

Hi Anonymous 

 

Please provide a screenshot of the table before you unpivoted.

 

thanks

Joe

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    JoeBarry This is how data looks like before unpivoted (screenshot from excel)