Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cluscombe
New Contributor III

Limiting table data load

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?

1 Solution

Accepted Solutions
oknotsen
Honored Contributor III

Re: Limiting table data load

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.

May you live in interesting times!
2 Replies
oknotsen
Honored Contributor III

Re: Limiting table data load

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.

May you live in interesting times!
cluscombe
New Contributor III

Re: Limiting table data load

Perfect! Thanks

Community Browser