Forum Discussion

MattAtBP's avatar
MattAtBP
Frequent Visitor
1 year ago
Solved

Split multiple columns and 'join/assign'

Hi, Recently got a data set that has multiple columns, each contain mulitiple values separated by pipe. I'm trying to separate them out, but then assign as shown below. The first instance / value of...
Need Help
  • slorin's avatar
    slorin
    1 year ago

    Hi,  MattAtBP 

     

    = Table.FromColumns(
      {
        List.Combine(List.Transform(YourSource[Risk ID], each Text.Split(_, " | "))), 
        List.Combine(List.Transform(YourSource[Risk Title], each Text.Split(_, " | ")))
      }, 
      {"Risk ID", "Risk Title"}
    )

    then sort by ID

     

    Stéphane

     

slorin's avatar
slorin
Super User
1 year ago

Hi,  MattAtBP 

 

= Table.FromColumns(
  {
    List.Combine(List.Transform(YourSource[Risk ID], each Text.Split(_, " | "))), 
    List.Combine(List.Transform(YourSource[Risk Title], each Text.Split(_, " | ")))
  }, 
  {"Risk ID", "Risk Title"}
)

then sort by ID

 

Stéphane