topic Like Join between two resident tables in QlikView

Like Join between two resident tables

Riccardo — Fri, 18 Nov 2016 11:51:16 GMT

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 — Fri, 18 Nov 2016 11:55:16 GMT

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

Anonymous — Fri, 18 Nov 2016 11:56:07 GMT

You may find this useful: