This content has been marked as final. Show 2 replies
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
(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..