Join 2 tables on name

Question

Hi Team,

I have a column with following data :

FruitsAppleBananaAvacadoCherry

I have to join to another table based on this column but with CONTAINS kind of logic

FruitsBananenBanaBananasCherry EMEAPine applePineapplesApplesApple SouthBig Apple

In output on joining both columns it needs to retreive all the matching data with contains logic something like

CONTAINS('Apple') then return the below and also needs to check only start with

ApplesApple SouthBig Apple

Thanks

Luke_C · Accepted Answer

Hi @JDong

Using the 'Append' option of the find and replace tool might be an easy solution, it will add a column and indicate what matched. You can then filter or use that column however you need.