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)})))
Hi wdx223_Daniel ,
Thanks for this. We're almost there. I can see where you've added in "Col_00" for the field name. I need this to start from 1 and go on, potentially beyond 10. How do I amend it to allow for this?