Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

schillo87
New Contributor II

Like Join between two resident tables

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

Tags (3)
2 Replies

Re: Like Join between two resident tables

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

Highlighted
qlikdeez
Valued Contributor

Re: Like Join between two resident tables

Community Browser