Limiting table data load

[cluscombe]

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?

[oknotsen · Accepted 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.

[cluscombe]

Perfect! Thanks