Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Would you be able to share few rows of data from both tables and show us the expected output from the sample data?
You may find this useful:
Joining two tables based on wildcard values. | Qlik Community