Forum Discussion
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 ...
Hi Anonymous
- Trim Attribute column (just to avoid extra "space" characters)
- Create a conditional column: if attribute = "Excalibur" then return "Solid" and so on...
- Remove first 4 rows
Hi Anonymous
- Trim Attribute column (just to avoid extra "space" characters)
- Create a conditional column: if attribute = "Excalibur" then return "Solid" and so on...
- Remove first 4 rows
Thanks mlsx4,
I understand the point of making the conditional columns, but in the future I will have more new attributes + values added and I want system to automatically recognize and link it with new value
And the point of create a duplication of the table after unpivot, filter (null values) for just keeping this:
As a master table, and then combine values on the original one (having previously filtered out the null values)