Forum Discussion

m_j_holland's avatar
m_j_holland
Regular Visitor
2 years ago
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...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    2 years ago

    =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)})))

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
2 years ago

=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)})))