Forum Discussion
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...
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
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
Thanks mahoneypat What if in addition I wanted to extract "name" and "primary". Primary is another value in the nested column available if I expand "name" Ideally the customer column would be:
name1, primary1, name2, primary 2