Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

francoisblouin
New Contributor

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

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!

Tags (1)
Community Browser