Help with Power Query to split JSON coded data
Hi All,
Hope you are doing well...I am trying to split the column of data containing JSON formatted data...I am trying to extract the following columns -complexity, the codes with type ICD-10-CM separated by columns and the clinicalencounterid.. Please find attached the file with the input and the expected output columns...Can you please help me here...
Thanks,
Arun
in OUPUT
Please Login or Register to view this content.
in B2
=json(Input!$B2,COLUMNS($B$1:B$1))
Copy across and down
As you have 365, I am sure there will be a formula solution,
Last edited by JohnTopley; 01-07-2022 at 01:38 AM.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
@ John Topley...Thanks !...This works...Really appreciate your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks