+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Forum Contributor
    Join Date
    10-18-2016
    Location
    Chicago, USA
    MS-Off Ver
    Office 365
    Posts
    186

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

    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...




    Thanks,
    Arun
    Attached Files Attached Files
    Last edited by chandramouliarun; 06-30-2021 at 01:37 AM.

  2. #2
    Forum Contributor
    Join Date
    10-18-2016
    Location
    Chicago, USA
    MS-Off Ver
    Office 365
    Posts
    186

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

    Hi Team..Any help on this would be much appreciated!..

    Thanks,
    Arun

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help with Power Query to extract values in JSON format
    By chandramouliarun in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-07-2021, 12:19 PM
  2. [SOLVED] Powerquery Help to help extract values from JSON data
    By chandramouliarun in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-23-2020, 01:25 AM
  3. Extract JSON Data values and identify the differences
    By chandramouliarun in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-05-2020, 11:48 PM
  4. Extract JSON Data values and identify the differences
    By chandramouliarun in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-03-2020, 02:03 PM
  5. Edit JSON parser code to add function to write JSON file
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-16-2020, 09:28 PM
  6. Macro JSON file object extract
    By yousufj56 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-16-2017, 07:30 PM
  7. [SOLVED] Invoking JSON SOAP Webservice With Parameter Using VBA
    By NeedForExcel in forum Excel Programming / VBA / Macros
    Replies: 33
    Last Post: 02-15-2016, 07:45 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1