How to use '%LIKE%' to join in Query transformation
I need to implement the below join condition in Query transformation.
FROM TABLE1 AS A, TABLE2 AS B
WHERE A.COL2 LIKE '%'+ B.COL2 +'%'
In Query transformation under expression, it is not allowing to add '%' (wild cards). It throws error message.
Also I have tried with lookup_ext function with operartor as ~.
Could you please suggest on this..
Thanks in advance !