Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.
Perfect! Thanks