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
slorin's avatar
slorin
Super User
2 years ago

Hi,

 

let
Source = Your_Source,
Custom1 = List.RemoveFirstN(Table.ColumnNames(Source),5),
Custom2 = List.RemoveFirstN(Record.ToList(Source{0}),5),
Data = Table.AddColumn(Source, "Data", each Table.FromColumns({ Custom1 , Custom2, List.RemoveFirstN(Record.ToList(_),5)})),
Custom3 = Table.RemoveColumns(Data,Custom1)
in
Custom3

then Expand

Stéphane