Help with powerquery to extract JSON parameter values from the data

Brass Contributor

Hi All,

Hope you are doing well!...I am trying to split the different parameter values for just the correct ,added and removed codes at a vbillid level..In the attached excel file the column codemap has the json from which the codes (belonging to removed, revised or added need to be extracted) from the different coding parameter categories such as cpt drg, modifiers, secondaryDiagnosis, principalDiagnosis, secondaryProcedure, observationhours , dischargeStatus ,principalprocedure,hcpcs

Attached the excel file with the input and the output data sheets...Can you please help me here...




Thanks,
Arun

1 Reply
Hi Team..Any help on this would be much appreciated!