Like Join between two resident tables

[Riccardo]

Hi everybody,

I have a table loaded from SQL Script and a table loaded from EXCEL Script.

I want to join them by one field, but I have to do a LIKE join with this field (MixMatch in qlik), because the field values don't matching.

In a normal SQL Script I can do this:

Select table1.*, table2.*

from table1, table2

where table1.field like '%' & table2.field & '%'

Can I do something similar with Qlik Script?

Thank you!! Regards,

Riccardo

[sunny_talwar]

Would you be able to share few rows of data from both tables and show us the expected output from the sample data?

[Anonymous]

You may find this useful:

Joining two tables based on wildcard values. | Qlik Community