Forum Discussion

jereaallikko's avatar
jereaallikko
Helper III
5 years ago
Solved

Help with expanding json list columns

Hi all,   I need help with modifying columns that contains List->Record. I am having a table of two columns : Id and Column1 and 82 rows. As shown below, Column1 contains List which needs to be ex...
Need Help
v-alq-msft's avatar
v-alq-msft
Community Support
5 years ago

Hi, jereaallikko 

 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

 

You may add a new step as below.

Table.Group(Source,"ID",{"Values",each Text.Combine([Value],",
")})

 

Result:

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

jereaallikko's avatar
jereaallikko
Helper III
5 years ago

Hi v-alq-msft 

 

Thanks for your reply. This would have probably been the easiest way to solve the problem. But as I applied the code to my dataset, an error occurs:

 

 

 

 

Any suggestions?