Discussion board where members can learn more about Qlik Sense Data Connectivity.
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?