topic Re: Joining two excel files on condition in QlikView https://community.qlik.com/t5/QlikView/Joining-two-excel-files-on-condition/m-p/1343590#M616464 <HTML><HEAD></HEAD><BODY><P>What if you used SELECT statement directly with in the script?? Is that code throwing any error?</P></BODY></HTML> Thu, 03 Aug 2017 16:29:03 GMT Anil_Babu_Samineni 2017-08-03T16:29:03Z Joining two excel files on condition https://community.qlik.com/t5/QlikView/Joining-two-excel-files-on-condition/m-p/1343589#M616463 <HTML><HEAD></HEAD><BODY><P>Hi guys, <BR />I am new to this community.</P><P></P><P>I am having trouble trying to join two tables in qliksense.</P><P>I am loading two tables from two excel files. I'd like to make a LEFT JOIN , using CONTAINS as condition. for example&nbsp; something like: </P><P></P><P>SELECT orderId, price</P><P>from Table1</P><P>LEFT JOIN</P><P>(Select product, description</P><P>from Table2) ON&nbsp; CONTAINS(Table2.description,Table1.orderID)</P><P></P><P></P><P>In other words I'd like to join only if&nbsp; the string "description" in Table2 contains the orderid of Table1.. <BR />Any idea?<BR />Thank you!</P></BODY></HTML> Thu, 03 Aug 2017 08:42:30 GMT https://community.qlik.com/t5/QlikView/Joining-two-excel-files-on-condition/m-p/1343589#M616463 2017-08-03T08:42:30Z Re: Joining two excel files on condition https://community.qlik.com/t5/QlikView/Joining-two-excel-files-on-condition/m-p/1343590#M616464 <HTML><HEAD></HEAD><BODY><P>What if you used SELECT statement directly with in the script?? Is that code throwing any error?</P></BODY></HTML> Thu, 03 Aug 2017 16:29:03 GMT https://community.qlik.com/t5/QlikView/Joining-two-excel-files-on-condition/m-p/1343590#M616464 Anil_Babu_Samineni 2017-08-03T16:29:03Z Re: Joining two excel files on condition https://community.qlik.com/t5/QlikView/Joining-two-excel-files-on-condition/m-p/1343591#M616465 <HTML><HEAD></HEAD><BODY><P>If you look at your data for table 2, does the orderID appear as the first x number of characters in the description?</P><P>Can you mock up some data for example</P></BODY></HTML> Fri, 04 Aug 2017 21:30:47 GMT https://community.qlik.com/t5/QlikView/Joining-two-excel-files-on-condition/m-p/1343591#M616465 mjtaft2017 2017-08-04T21:30:47Z