+ Reply to Thread
Results 1 to 3 of 3

Help with Power Query to Split JSON into Columns

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

    Red face Help with Power Query to Split JSON into Columns

    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.. Can you please help here..

    Thanks,
    Arun
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Help with Power Query to Split JSON into Columns

    Please try

    HTML Code: 
    Attached Files Attached Files

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

    Re: Help with Power Query to Split JSON into Columns

    @Bo_Ry: This works!..Really appreciate your help!

+ 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. Power Query/VBA JSON Extraction
    By VinchinzoB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-29-2020, 11:44 AM
  2. Power Query takes ages to load JSON data from web
    By rohanrao in forum Excel General
    Replies: 4
    Last Post: 05-21-2020, 10:34 PM
  3. [SOLVED] Power Query - excel formula translation into Power Query
    By afgi in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 02-19-2020, 03:38 AM
  4. Replies: 4
    Last Post: 02-17-2020, 06:03 AM
  5. [SOLVED] Power Query to Split a Column
    By andrewc in forum Excel General
    Replies: 5
    Last Post: 07-27-2019, 01:00 PM
  6. Custom Permutations Column in Power Query from two columns in the same Query
    By PaintPaddy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2019, 02:48 PM
  7. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM

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