Forum Discussion

Arun Chandramouli's avatar
Arun Chandramouli
Brass Contributor
Jan 09, 2022
Solved

Help with Power Query to extract CPT and ICD codes data

Hi All,

Hope you are doing well!...I am trying to extract the CPT and the ICD codes data from the coded data column Data which is in JSON format..Please find attached the sheet with the input data and the output required data.. Can you please help me here...


Thanks,
Arun

BI & Data Analysis
excel
Formulas and Functions
Macros and VBA

5 Replies

    • Arun Chandramouli's avatar
      Arun Chandramouli
      Brass Contributor
      Jan 10, 2022
      Hi @alanavarro...Really appreciate your response..The only error that I am getting is that "We cannot convert the value null to type text"...This happens because in some of my rows of data either the CPT code is not at all available or the ICD code is not at all available...
      • alannavarro's avatar
        alannavarro
        Iron Contributor
        Jan 10, 2022
        Hello, could you please attach an excel file with the error?

Resources