Discussion board where members can learn more about Qlik Sense App Development and Usage.
Lets say I have two tables, lets call them table A and B.
Table A - contains 100 customer transactions. These are the transactions that I care about
Table B – contains 1,000,000 customer records that could be related the 100 customer transactions in table A.
I want to load the data from Table A and Table B into a QS App, but I want to load the customer records from Table B only to the extent that those records are related to the transactions in table A.
How can I do that in the load script?
Go to Solution.
Let's assume the key field for both tableA and tableB is named fieldKey, add this where clause to the load of the 2nd table:
where exists (fieldKey)
That way, it will only load the records from tableB that have a fieldKey in tableA.