Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Power Query searching for text between 2 columns

Hi all,   2 part question, hopefully pretty simple.  I have 2 tables, I'm trying to search a column in 1 table for values in a column on a second table.  I want it to return the matched value when ...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    Just use List.First instead of Text.Combine (and delete the , ",") 

    Regards,

    Pat

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

Just use List.First instead of Text.Combine (and delete the , ",") 

Regards,

Pat

Anonymous's avatar
Anonymous
Not applicable
5 years ago

mahoneypat 

 

Thanks for the speedy reply.  Looks to have helped a lot, I also figured out the second part of the question.  Still a leftover issue if you could help.

 

My list of search words list in a specific order to get the right result.  EG -

Text to be searched - "User has disconnected"

 

My list is ordered "disconnect" then "connect".  That should make it flag as 'disconnect' rather than 'connect', but it seems hit and miss which the code is finding.