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...
- May 27, 2019
As Damien_Rosario suggests, type the number 1936 or text '1936 into the top cell A2.
Then double-click the fill handle at the bottom right of the cell and the value will fill down to match adjacent columns.
Another possibility to consider is inputting the value 13150. That is the date value for the 1/1/1936 and the custom number format can be set to display 1936.
The options make no difference if the value is just for visual effect but if the field is referenced by formulas it is worth getting it right.
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