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:

      SELECT A.ID, B.ID

      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!