Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Joining two excel files on condition

Hi guys,
I am new to this community.

I am having trouble trying to join two tables in qliksense.

I am loading two tables from two excel files. I'd like to make a LEFT JOIN , using CONTAINS as condition. for example  something like:

SELECT orderId, price

from Table1

LEFT JOIN

(Select product, description

from Table2) ON  CONTAINS(Table2.description,Table1.orderID)

In other words I'd like to join only if  the string "description" in Table2 contains the orderid of Table1..
Any idea?
Thank you!

2 Replies
loveisfail
Not applicable

Re: Joining two excel files on condition

What if you used SELECT statement directly with in the script?? Is that code throwing any error?

Life is so rich, and we need to respect to the life !!!
mjtaft2017
Not applicable

Re: Joining two excel files on condition

If you look at your data for table 2, does the orderID appear as the first x number of characters in the description?

Can you mock up some data for example