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
ChiragGarg2512's avatar
ChiragGarg2512
Icon for Solution Sage rankSolution 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.