2 Replies Latest reply: Nov 18, 2016 6:56 AM by Deran Naidoo RSS

    Like Join between two resident tables

    Riccardo Schillaci

      Hi everybody,

       

      I have a table loaded from SQL Script and a table loaded from EXCEL Script.

       

      I want to join them by one field, but I have to do a LIKE join with this field (MixMatch in qlik), because the field values don't matching.

       

      In a normal SQL Script I can do this:

       

      Select table1.*, table2.*

      from table1, table2

      where table1.field like '%' & table2.field & '%'

       

      Can I do something similar with Qlik Script?

       

       

      Thank you!! Regards,

      Riccardo