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

Anonymous — Tue, 29 Aug 2017 16:21:39 GMT

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!

topic Qlik Sense - (ETL) Script with condition from 2 sources in Connectivity & Data Prep