Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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

Riccardo Schillaci
BI Technical Analyst
Datawarehouse & Business Intelligence
2 Replies
Highlighted

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

Highlighted
Specialist
Specialist