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
wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
2 years ago

NewStep=Table.AddColumn(Table.Skip(#"Unpiovted Other Columns",4),"Type",Function.ScalarVector(Value.Type(each _) as any,(t)=>let a=#"Unpiovted Other Columns"[Value] in List.Repeat(List.FirstN(a,4),List.Count(a)/4-1)))