Forum Discussion

Jun_Wang's avatar
Jun_Wang
Icon for Advocate I rankAdvocate I
7 years ago
Solved

any function can do exact match (text) in power query?

I'm quite new to power query. I used to run some M functions in power query to do keywords searching and assign these rows with specific keywords to a category. But it has some issues now. I need exa...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    You may download my solution Excel file from here.  Go to PowerPivot > Manage

    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Jun_Wang,

 

It works for me, please find the below screenshot for your reference.

 

 

 

 

 

 

 

 

Go to Edit Queries --> Select the column (Text) --> Add Column Tab --> Conditional Column --> and give the details as in the screenshot. It will work.

 

Please let me know if you still have any questions. Happy to help you.

 

Regards,

Pavan Vanguri.

Jun_Wang's avatar
Jun_Wang
Icon for Advocate I rankAdvocate I
7 years ago

Thanks Pavan, but this fix is not very ideal to me. My dataset normally has 10k rows, the "block" is not the only possible word containing string "^lock". It could be blockade, block, blockage, even sherlock........

 

I reckon exact match would be easier :)

 

 

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    7 years ago

    padlock is not an exact match.  Therefore why should that be a part of your result?