Results 1 to 2 of 2

Help with powerquery to extract JSON parameter values from the data

Threaded View

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

    Red face Help with powerquery 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...
    Attached Files Attached Files

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 JSON parameter values from the data
    By chandramouliarun in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-30-2021, 01:37 AM
  2. Help with Powerquery to extract feedback values in the input data
    By chandramouliarun in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-08-2021, 01:18 AM
  3. Extracting JSON Data from variables that have multiple data points-Help with Powerquery
    By chandramouliarun in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-15-2021, 01:52 AM
  4. [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
  5. 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
  6. 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
  7. Automate Powerquery JSON File Import with VBA
    By Chris.Leo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-11-2020, 11:26 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