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,