Results 1 to 3 of 3

Thread: Power Query - Filter A List Of Strings Based On Non Exact Values In Another Table

  1. #1
    Neophyte bravo1563's Avatar
    Join Date
    Nov 2019
    Posts
    2
    Articles
    0
    Excel Version
    2018

    Power Query - Filter A List Of Strings Based On Non Exact Values In Another Table



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello I've seen a few posts that have similar issue but I have not seen what I'm trying to accomplish.

    I have two tables, "CriteriaTbl" and "TextTbl" I need find the text where the criteria is contained and return the corresponding value. I have several thousand criterias and many thousand more texts so manual finds would not be sufficient and I need to keep in power query. I've created a function which filters for the first color but I have not come up with a way to assign it a color and value and loop through the rest of the list. Attached is my sample file, I appreciate any help anyone can provide. Thanks!


    CriteriaTbl TextTbl Desired Output
    Criteria Value Text Text Criteria Value
    Red 1 The ball is red. The ball is red. Red 1
    Green 2 Putting on the greens with my red ball. Putting on the greens with my red ball. Green 2
    Blue -1 Feeling blue? Wear your green shirt. Putting on the greens with my red ball. Red 1
    The ball is orange Feeling blue? Wear your green shirt. Blue -1
    Feeling blue? Wear your green shirt. Green 2
    The ball is orange null null
    Attached Files Attached Files

  2. #2
    Conjurer Bill Szysz's Avatar
    Join Date
    Apr 2016
    Location
    Poznań, Poland Dublin, Ireland
    Posts
    103
    Articles
    0
    Excel Version
    Excel 365
    Check it out.

    Cheers
    Attached Files Attached Files

  3. #3
    Neophyte bravo1563's Avatar
    Join Date
    Nov 2019
    Posts
    2
    Articles
    0
    Excel Version
    2018
    Thanks Bill this is exactly what I was looking for!

Tags for this Thread

Posting Permissions

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