Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Split

  Hi guys,   can anybody help me? Please   The column called phase_history has a sequence of steps in my pipeline and first_time_in has the sequence of dates referring to each step of phase_hist...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    4 years ago
    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCi5JLCpRSMsvytUJKMrMTc0syldIzs8rSSzJV3AMdgxAiKZkJiqkpMIklXSUjAyMDHUNzHUNTUIMDKyMzK0MzbWBDAMDHUwZC6wyxmZWJlAZpVgd6jjGIsTAELtj4DIYjgHLoDgmFgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [phase_history = _t, first_time_in = _t]),

    ToRows = Table.ToRows(Source),
    #"Split Rows" = let cols = Table.ColumnNames(Source) in List.Transform(ToRows, each Table.FromColumns(List.Transform(_, each Text.Split(_, ",")), cols)),
    #"Combined Tables" = Table.Combine(#"Split Rows")
in
    #"Combined Tables"