Powerquery Help to help extract values from JSON data

Hi All,

Hope you are doing well! I seek your help in extracting the JSON data in column in column info in the attached excel worksheet (Input)..I need to extract chargeCode,diagnosisCode,modifiers,hcpcsUnits from the info column...The first json row order by created ascending order with the pair of Billid and ctextid is done by coder and the second by auditor.. Can you please help here.. Attached the excel worksheet with the output expected in the second sheet...

Thanks,
Arun

this will be of use to you:

https://support.microsoft.com/en-us/...a-50dded6e4a68

so will this:

https://support.microsoft.com/en-us/...1-63f26a86c0eb

and if you have advanced coding skills, the REGEX() function is incredibly useful in a scenario like this:

https://docs.microsoft.com/en-us/dot...n-object-model

but if the coding skills are limited, just loop the sheet from top to bottom and use string functions to find everything you need:

https://docs.microsoft.com/en-us/dot...ring-functions

INSTR() will be of utmost importance.

these are coding solutions though. I'm no PQ expert. if it can do it, then that would obviously be easier.

I realize that ali, but why not give other things? many ways to skin a cat. you know that.

If you want VBA like your first thread
Compare JSON data and splitting into corrected codes, deleted codes and added codes

Please Login or Register  to view this content.

Thank you so much @Bo_ry and @Jindon..Appreciate your help!!...

Thanks AliGW!!