+ Reply to Thread
Results 1 to 4 of 4

Help with Power Query to extract only matching codes from reference codes

  1. 01-07-2022, 05:30 AM #1
    chandramouliarun
    chandramouliarun is offline
    Forum Contributor
    Join Date
    10-18-2016
    Location
    Chicago, USA
    MS-Off Ver
    Office 365
    Posts
    220

    Red face Help with Power Query to extract only matching codes from reference codes

    Hi All,

    Hope you are doing well!.. I am trying to extract the matching codes from the column diagcode in my input data with respect to the list of reference diag codes.. The output diag codes are the ones extracted from the column diagcode with respect to the matching reference diag codes...Can you please help me here...



    Thanks,
    Arun
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-07-2022, 05:43 AM #2
    AliGW
    AliGW is offline
    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 Power Query to extract only matching codes from reference codes

    Step 1 (with the main table):

    Please Login or Register  to view this content.
    Step 2 (with the looklup table):

    Please Login or Register  to view this content.
    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.
    Reply With QuoteRegister To Reply
  3. 01-07-2022, 05:52 AM #3
    chandramouliarun
    chandramouliarun is offline
    Forum Contributor
    Join Date
    10-18-2016
    Location
    Chicago, USA
    MS-Off Ver
    Office 365
    Posts
    220

    Re: Help with Power Query to extract only matching codes from reference codes

    Thank you so much @AliGw...Really appreciate your help!
    Reply With QuoteRegister To Reply
  4. 01-07-2022, 05:57 AM #4
    AliGW
    AliGW is offline
    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 Power Query to extract only matching codes from reference codes

    Pleasure!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Help with Formula/ Power query to get the number of matching row counts of codes
    By chandramouliarun in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-10-2022, 08:14 AM
  2. Help with Power Query to Count Diagnosis codes
    By chandramouliarun in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-05-2021, 09:42 AM
  3. [SOLVED] Finding the Added and Deleted Codes out of the two sets of Codes Entered
    By chandramouliarun in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 12-08-2020, 10:10 AM
  4. [SOLVED] Compare JSON data and splitting into corrected codes, deleted codes and added codes
    By chandramouliarun in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 12-01-2020, 06:46 AM
  5. [SOLVED] Compare JSON data and splitting into corrected codes, deleted codes and added codes
    By chandramouliarun in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-29-2020, 12:06 PM
  6. How to split dialing codes into country code and area codes
    By stefansfs in forum Excel General
    Replies: 7
    Last Post: 08-13-2015, 10:58 AM
  7. matching codes between 2 item codes
    By JChan in forum Excel General
    Replies: 1
    Last Post: 10-15-2005, 01:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1