SOLVED

Help with Power Query to extract values in JSON format

%3CLINGO-SUB%20id%3D%22lingo-sub-2424931%22%20slang%3D%22en-US%22%3EHelp%20with%20Power%20Query%20to%20extract%20values%20in%20JSON%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2424931%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%20Team%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EHope%20you%20are%20doing%20well!..%20Please%20find%20the%20excel%20workbook%20with%20the%20input%20and%20the%20output%20tabs...The%20input%20tab%20has%20the%20autoinfo%20column%20in%20json%20format%20and%20then%20in%20the%20output%20tab%20the%20column%20values%20are%20extracted%20from%20the%20same%20json%20column%20..Can%20you%20please%20help%20me%20with%20a%20power%20query%20for%20the%20same..%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EThanks%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EArun%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2424931%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2426155%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Power%20Query%20to%20extract%20values%20in%20JSON%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2426155%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F216929%22%20target%3D%22_blank%22%3E%40Arun%20Chandramouli%3C%2FA%3E%26nbsp%3BThe%20attached%20file%20contains%20a%20query%20that%20parses%20the%20JSON%20column%20similar%20to%20your%20example%20output%2C%20where%20not%20all%20the%20columns%20are%20included.%20and%20the%20exact%20order%20of%20the%20columns%20isn't%20the%20same%20either.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2442652%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Power%20Query%20to%20extract%20values%20in%20JSON%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2442652%22%20slang%3D%22en-US%22%3EThank%20you%20so%20much%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%20...Really%20appreciate%20your%20help!..%3C%2FLINGO-BODY%3E
Occasional Contributor

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

2 Replies
best response confirmed by Arun Chandramouli (Occasional Contributor)
Solution

@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!..