Search for multiple keywords in one column using Power Query

[@davidfamilydoctor9430]

Exactly what i needed. I have one file that combines three data sets. One column that has four tags separated by colon. However, each data set has a different order for the tags in that column. This video explains how to just search the column. I need to see which client is listed in my data. I will search against our cliemt list. I expected the video to end with a Group By. But filter by True did this. My lengthy and not scalable approach to make it work this week was to do a multi level conditional column to check for top five clients. I used column-contains feature.

[@carneypwr]

OMG Thank you! This is just what I needed for my competition.

[@nicopita77]

Ruth ,,, Thanks a lot... You help us a lot with your videos .. Greetings from Argentina

[@CurbalEN]

Thanks Nicolas :)

[@tarekyeh6245]

Thank you so much , I was looking for more complex solutions , but this simple one solved it for me, the only downside is large data takes time.

[@rishabjain4774]

Found the solution? @tarekyeh6245

[@saharsalehi8070]

Thanks a lot for the strightforward , easy solution. super helpful!

[@__Blank___]

you saved my day sweet heart

[@marttitube]

Hi, Thank You for this version for shorter lists of words. I have larger table and it takes a lot of time to calculate alla matches. I would like to hear other solution that demands "more brain power :)".

[@CurbalEN]

For larger tables Power Query is not the best option. Do it at the source if possible.

[@abhishekstatus_7]

Thanks for sharing Ruth 🤗😊

[@CurbalEN]

Yey!! 😊

[@abhishekstatus_7]

@@CurbalEN 🤗🤗

[@opinionluggir]

Nice job 🎉🎉🎉

[@oliverscheurich9202]

Great. You should have 1.030.000 subscribers instead of 103.000.

[@CurbalEN]

😊

[@dereklowry3111]

Excellent, thank you

[@cindyc6703]

What number is for this download file? it can allow me to practice.

[@mansijswarnkar2183]

Great, thanks a ton !!

[@ccs2336]

Teacher you are the best! I want to ask the teacher what is the URL of the document about the formula?

[@CurbalEN]

I can’t share this data, so no url for this :(

[@ccs2336]

Sorry, maybe I didn't make it clear. I don't want that data. I want to know the documentation of the m formula, I searched Microsoft's help documentation and didn't see it.

[@paulgallagher2987]

@@ccs2336 It's here: learn.microsoft.com/en-us/powerquery-m/text-contains

[@daveroydun11]

Thank you!

[@barboradolezalova7389]

Hello Ruth! Greetings from Czech Republic. Thank you for your vieos, I just found them. They are super helpfull. Yeat I am strugling with one task in my homework on movies and tv shows. What I am trying to do is "tell what combination of countries cooperation did the most titles" I was hopeing that "search for multiple keywords" would do the trick. However its not working as how I would like. Do you have any sugestions what to try to make it work?

[@VarunSharma-jj9sm]

Mam, i had question. What to do with those who are not matching ie.False. Now if i want to solve that false figure manually, then i can't since they have many duplicates including true figure.

[@mccalabb]

Nice, but the #"table"[column] not working in my excel worksheet. is it not working in excel?

[@danishnawaz3651]

plz make video for below. If 1 table has 9 column, 2 table has 10 and 3 table has 8 . Then how can we make equal all column for all table.. like we want to insert dummy column for missing column in tables and make equal like 10 column for each table.

[@yousuforyakhailguchnjrhpy9479]

it work on my pc thx bro vеry much

[@CurbalEN]

👊

[@anfiiiii]

Thanks

[@davidfamilydoctor9430]

I expected the column names to autocomplete when typing them within the double-square brackets.

[@ale.trouble]

Estuve atorado con esto como un dia entero, bendito sea el carpintero que corto la madera para hacer la base de la cama donde tus padres hecharon pasión para traerte al mundo, experta en power bi.

[@CurbalEN]

😂😂 ya se lo digo!

[@forthree7805]

First!

[@CurbalEN]

You are!! 👏👏

[@forthree7805]

@@CurbalEN been learning a lot from you. You deserve the MVP award!

[@CurbalEN]

Thank you 😊!

[@unboxingcategory3353]

amazing

[@bboykaze9538]

Thank you for comparer.ordinal ignorecase !

[@CurbalEN]

Neat right?

[@zoranmilokanovic6229]

I guess this is method that you used for the DAX spoiler of the #25DAYSOFDAXFRIDAYS 😊

[@CurbalEN]

It is :)

[@zoranmilokanovic6229]

The only drawback I see, if someone used comments in the dax code (like me ;)) and mentioned any of the DAX functions in it you will count it as well. I guess this could be treated as a noise and won't influence final result that much.

[@CurbalEN]

Yeah, there is always a margin of error with untidy data, but this is hopefully good enough ;)

[@christianhartgrove]

THANK YOU!