Hi All,
Hope you are doing well! I seek your help in extracting the JSON data in column in column info in the attached excel worksheet (Input)..I need to extract cCode,dCode,mod,hcpc from the info column...The first json row order by created ascending order with the pair of Billid and ctextid is done by coder and the second by auditor.. The power query is already in place for the above...The only issue is that for mod if the data has more than one data point seperated by commas (for ex(67,102): the powerquery only extracts the first data point 67. Can you please help me here..Please find attached the data file with the input and output tabs :with the output tab having the powerquery output as well which is different from the actual expected output for mod...
Can you please help me here....
Thanks,
Arun
Bookmarks