Forum Discussion

jpt1228's avatar
jpt1228
Responsive Resident
5 years ago
Solved

Expanding JSON column results in adding rows

Hello, I have a JSON file from an API endpoint which has many nested columns. When I click hiring.team expand I get 3 columns which are hiring_managers, recruiters, coordinators. If I want to get the...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    You can add a custom column with this formula to concatenate the recruiters.  

    = Text.Combine(List.Transform([hiring_managers], each Record.Field(_, "name")), ", ")

     

    Regards,

    Pat

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

You can adapt it like this to do that.

 

= Text.Combine(List.Transform([hiring_managers], each Record.Field(_, "name") & ", " & Record.Field(_, "primary")), "; ")

 

Pat