Forum Discussion

PoojaTekriwal's avatar
PoojaTekriwal
Regular Visitor
5 years ago
Solved

Split a column based on where condition from another column

want to split a column contaning this value asset-symbol column name C 21/03/19 C 72.000   into 4 new column where my assetype(another column containing values equity,option)=equity
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Please try to add 2 new columns:

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclYwMtQ3MNY3tFRwVjA30jMwUNJRctXxV4rViVZy93WFShuYAqWNzE1R5b1dQRwwMyTYxxFhVICCqYGBAapiR9+gYIjyWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Text.BeforeDelimiter([Column1], " ")),
    #"Added Custom1" = Table.AddColumn(#"Added Custom", "Custom.1", each Text.BetweenDelimiters([Column1], " ", ".", 2, 1))
in
    #"Added Custom1"

     

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
5 years ago

Please try to add 2 new columns:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclYwMtQ3MNY3tFRwVjA30jMwUNJRctXxV4rViVZy93WFShuYAqWNzE1R5b1dQRwwMyTYxxFhVICCqYGBAapiR9+gYIjyWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Text.BeforeDelimiter([Column1], " ")),
    #"Added Custom1" = Table.AddColumn(#"Added Custom", "Custom.1", each Text.BetweenDelimiters([Column1], " ", ".", 2, 1))
in
    #"Added Custom1"