Forum Discussion
Solved
Split Column by Dynamic Delimiters in another Field
Hi, I'm using Power Query to split a field by a delimiter in another field. Below is an example of the data I'm using: In the above example, I want to split the field "expected_patte...
=Table.Combine(List.Transform(Table.ToRecords(#"Filtered Taxonomy Field"),each let a=Text.Split([expected_pattern],[expected_delimiter]) in Table.FromRecords({Record.TransformFields(_,List.Transform(List.Positions(a),(x)=>{"Col_"&Number.ToText(x,"00"),each a{x}}),2)})))
I've figured it out. I've amended it to this ...
{"Col_"&Number.ToText(x+1,"00"),each a{x}}),2)})))
Thanks,
Mark