Forum Discussion

KristianVangen's avatar
KristianVangen
Frequent Visitor
3 years ago
Solved

Split column by value in row

Hi. Cannot figure out what to look for here, so this question is probably answered somewhere else.   I have data in a .txt file structured like this   Column1: ValueX --- --- --- --- Column2: ...
Need Help
  • latimeria's avatar
    latimeria
    3 years ago

    Hi KristianVangen ,

    Try this:

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCkvMKU2NUNKBMAyVYnWgYpEwMSOwGIxnjFARBRMzQVFhisIDmhgLAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t]),
    #"Replaced Value" = Table.ReplaceValue(Source,"",null,Replacer.ReplaceValue,{"Column1"}),
    #"Filled Down" = Table.FillDown(#"Replaced Value",{"Column1"})
in
    #"Filled Down"
latimeria's avatar
latimeria
Solution Specialist
3 years ago

Hi KristianVangen ,

Try this:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCkvMKU2NUNKBMAyVYnWgYpEwMSOwGIxnjFARBRMzQVFhisIDmhgLAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t]),
    #"Replaced Value" = Table.ReplaceValue(Source,"",null,Replacer.ReplaceValue,{"Column1"}),
    #"Filled Down" = Table.FillDown(#"Replaced Value",{"Column1"})
in
    #"Filled Down"