2 Replies Latest reply: Aug 4, 2017 5:30 PM by Mary Jo Taft RSS

    Joining two excel files on condition

    Michele Ippoliti

      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!