+ Reply to Thread
Results 1 to 7 of 7

Help with PowerQuery to populate the error codes list from coding activity

  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 populate the error codes list from coding activity

    Hi All,

    Hope you are doing well!..Wishing you a happy new year...I am trying to populate the error codes based on the coding activity.. In my Input excel sheet combination if Billid and ctextid indicate the a specific patient visit and the coder indicates the first person who codes the patient visit and then the Auditor is the second person who does the checking of the work done by the coder corrects if it has any mistakes and also adds if any ..So final correct version of the code is the one done by the auditor...The error codes are the ones who are not there in the coder version and are there in the auditor version..Added codes are the ones that are there in the auditor version but are not there in the coder version...Both the added codes and the deleted codes are the error codes for that patient visit (combination of ctextid and billid).. Attached the excel sheet with the input and the needed output tabs..Can you please help me here...

    Thanks,
    Arun
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Help with PowerQuery to populate the error codes list from coding activity

    I am not sure your sample output is quite right.

    M Code:

    Please Login or Register  to view this content.
    Please update your user profile, as I suspect you are now using a more recent version of Excel.
    Attached Files Attached Files
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

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

    Re: Help with PowerQuery to populate the error codes list from coding activity

    Please try

    Please Login or Register  to view this content.
    Attached Files Attached Files

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

    Re: Help with PowerQuery to populate the error codes list from coding activity

    @AliGW : Sure ...Appreciate your help!..Yes I will update the excel version to my user profile...Sorry yes I accept the output was wrong...Will make sure that I double check them..

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

    Re: Help with PowerQuery to populate the error codes list from coding activity

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

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Help with PowerQuery to populate the error codes list from coding activity

    My solution works, as well, but Bo_Ry's is slicker.

    Thanks for then rep.

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

    Re: Help with PowerQuery to populate the error codes list from coding activity

    @AliGW: Yes your solution works as well!..Sorry for not mentioning that!!...Hope you have a great day!

+ 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. PowerQuery in Excel: Use an Excel table to populate SQL table in PowerQuery
    By joeyslaptop in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-25-2019, 02:33 PM
  2. Activity Calendar - Cell won't populate (INDEX & MATCH related)
    By greentea in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-15-2018, 11:53 AM
  3. Replies: 8
    Last Post: 05-12-2017, 01:05 PM
  4. HELP - How to Auto-populate excel calendar with event / activity data
    By Veronica S in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2014, 01:22 PM
  5. Activity Time Tracker to capture activity selected from dropdown list
    By dillibabu in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-24-2013, 01:10 PM
  6. List of Runtime Error Codes
    By DCSwearingen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-21-2013, 09:13 PM
  7. [SOLVED] Populate list of user defined codes with checked data
    By johnmarkp in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-08-2013, 04:02 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