Forum Discussion
Solved
Help with Power Query to extract values in JSON format
Hi Team,
Hope you are doing well!.. Please find the excel workbook with the input and the output tabs...The input tab has the autoinfo column in json format and then in the output tab the column values are extracted from the same json column ..Can you please help me with a power query for the same..
Thanks,
Arun
Arun Chandramouli The attached file contains a query that parses the JSON column similar to your example output, where not all the columns are included. and the exact order of the columns isn't the same either.
2 Replies
Arun Chandramouli The attached file contains a query that parses the JSON column similar to your example output, where not all the columns are included. and the exact order of the columns isn't the same either.
- Thank you so much Riny_van_Eekelen ...Really appreciate your help!..
