Forum Discussion
Arun Chandramouli
Jan 09, 2022Brass Contributor
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...
- Jan 09, 2022
alannavarro
Jan 09, 2022Iron Contributor
- Arun ChandramouliJan 10, 2022Brass ContributorHi @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...
- alannavarroJan 10, 2022Iron ContributorHello, could you please attach an excel file with the error?
- Arun ChandramouliJan 10, 2022Brass ContributorHi Alannavarro...I used the power query only till the Grouped rows stage and I was able to use the data