0 Replies Latest reply: Aug 29, 2017 1:48 PM by Francois Blouin RSS

    Qlik Sense - (ETL) Script with condition from 2 sources

    Francois Blouin

      Hello, I am new with Qlik sense version 3.2


      I have a data source in a BD (Table A) and a second data source in an Excel file (Table B).

      Source A contains transactions (with a specific date) and source B contains 2 dates (beginning and end of a period).

      I would like to associate each transaction with a period.


      In short, my SQL should be:


      FROM source.TableA as A, source.TableB as B

      WHERE A.Date> = B.DateDebut AND A.Date <= B.DateFin


      How can I have this result in a section of the Scipt of Qlik Sense?


      Thank you!