Match parts of strings in a lookup table and return another column

[omezquita]

Hi,

I have a column with texts:



and I want to match parts of those strings with a lookup column in another table and return another column:


The end result should look like this:


Thanks!

 

[Comfy]

This Post by Chris Webb has everything you need: https://blog.crossjoin.co.uk/2014/06/02/join-conditions-in-power-query-part-1/

I've attached an example.

 

[omezquita]

This Post by Chris Webb has everything you need: https://blog.crossjoin.co.uk/2014/06/02/join-conditions-in-power-query-part-1/

I've attached an example.

Thanks a lot!!! This solves the problem as I posted it.

However, when trying to implement with my own data I see that the final table doesn't show the rows where there's no match. Would it be possible to retain the rows where there's no match?

 

[Comfy]

You could append the original Table and then remove the duplicates??

 

[omezquita]

OF COURSE!!!

Thanks!