Joining two excel files on condition

[#1]

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!

[Anil_Babu_Samineni]

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

[mjtaft2017]

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