Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

help needed with power query transform

i have a excel spreadhseet with one of the column like in the screenshot below.  I tried to transform to JSON but its throwing error. How to expand those columns inside the brackets .

Need Help

3 Replies

  • ChiragGarg2512's avatar
    ChiragGarg2512
    Solution Sage
    2 years ago

    Anonymous Make a json where all of these are objects, then just uploading the data through json should do the work.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      I am getting this data from excel spreadsheet in this format. How to make json from this data?

  • ChiragGarg2512's avatar
    ChiragGarg2512
    Solution Sage
    2 years ago

    Anonymous , Use any excel to json online convertor. Caution that the excel that is provided only has the above column. 

    OR

    Replace every ' by " and } by }, and in the same way introduce commas between every key-value pair. Paste all of the values in [ ]  in notepad and save it as .json .

     

    Also that no two values have , between them, i.e. notificationID and unreachableCount are not differentiated.