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?  

    • Jimmy801's avatar
      Jimmy801
      Community Champion
      5 years ago

      Hello jereaallikko 

       

      did you check my solution?

       

      BR

       

      Jimmy

      • jereaallikko's avatar
        jereaallikko
        Helper III
        5 years ago

        Hello Jimmy801 

         

        Yes, I did. It would also work, if the dataset and the amount of rows were be smaller. As the dataset contains over 80 rows, the manual work with that solution would be too much. Additionally, each time new data is rolling in, I should make modifications with advanced editor according to the new data.

         

        Thanks anyways for the solution. If nothing more simple appears, this is probably the solution I must use.

         

        Do you have any more simple solution to suggest?

         

        Br, Jere