Forum Discussion

Anonymous

Not applicable

3 years ago

Solved

JSON file upload to PowerBI

Converting a column record to a list - Resolved

Data Protection

Tips and Tricks

Anonymous
3 years ago
The code in Advanced Editor was changed to read the data as CSV documents to combine the column data before converting to JSON. This allowed me convert the column to a list then created custom columns pulling the values from those list to create a string of values separated by a delimiter.

3 Replies

ImkeF
Community Champion
3 years ago
Hi Anonymous ,
if the color indicators are correct, the comma separates a nested record within the main list of records.
So there must be some transformations in the expansion-steps that cause the result you're seeing.
Are you able to post the M-code that has been generated?
- Anonymous
  Not applicable
  3 years ago
  I've resolved the issue
  - Anonymous
    Not applicable
    3 years ago
    The code in Advanced Editor was changed to read the data as CSV documents to combine the column data before converting to JSON. This allowed me convert the column to a list then created custom columns pulling the values from those list to create a string of values separated by a delimiter.