Help with powerquery to extract JSON parameter values from the data

**chandramouliarun** · 06-23-2021, 03:22 AM

Hi All,

Hope you are doing well!...I am trying to split the different parameter values for just the correct ,added and removed codes at a vbillid level..In the attached excel file the column codemap has the json from which the codes (belonging to removed, revised or added need to be extracted) from the different coding parameter categories such as cpt drg, modifiers, secondaryDiagnosis, principalDiagnosis, secondaryProcedure, observationhours , dischargeStatus ,principalprocedure,hcpcs

Attached the excel file with the input and the output data sheets...Can you please help me here...

**alansidman** · 06-23-2021, 03:28 AM

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...-the-data.html

Help with powerquery to extract JSON parameter values from the data

LinkBack

Thread Tools

Display

Help with powerquery to extract JSON parameter values from the data

Re: Help with powerquery to extract JSON parameter values from the data

Thread Information

Users Browsing this Thread

Similar Threads

Help with Power Query to extract JSON parameter values from the data

Help with Powerquery to extract feedback values in the input data

Extracting JSON Data from variables that have multiple data points-Help with Powerquery

[SOLVED] Powerquery Help to help extract values from JSON data

Extract JSON Data values and identify the differences

Extract JSON Data values and identify the differences

Automate Powerquery JSON File Import with VBA

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions