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"

mussaenda's avatar
mussaenda
Community Champion
4 years ago

Hi Anonymous ,

 

You can use split with delimiter.

If you need help on splitting, provide a workable data.

 

Thank you.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

mussaendaA sample of data follows. I've been trying and I can't get the result I need to get.

 

https://ufile.io/zmfwpgib

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous 

    I think   's reply has shown you a correct way to solve your problem. ToRow,Split Rows and Combined Tables.

    It seems that I don't have access to your data source. I couldn't do transform in Power Query Editor. If you still have problem, you can build a sample by Enter Data instead of Get data.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • mussaenda's avatar
    mussaenda
    Community Champion
    4 years ago

    Hi Anonymous ,

     

    You attached pbix is connected to an excel where we cannot access.

    Please provide also the excel connected to your sample pbix so we can help you to implement CNENFRNL ' solution

     

     
    Thank you