WHERE clause on QVD load

[jheasley]

Good Morning,

Need some help on a load script.  I have 3 tables (items, batches, Searches).  Items is a fact table, and the other two are hybrid fact/dim tables, all in QVD form. I have a where clause on Items, pulling only the last 28 days.  How do I write a where clause on Batches and Notes that looks at the key and date from Items?

[stabben23 · Accepted solution]

Hi,

like this:

where Exists( ITEMNUM) in Your ONBASENOTES table

where Exists( BATCHNUM) in Your ONBASEBATCHES table

[jheasley]

I am not only looking for existence of the value, but where the date >= Today()-28. Where would I define that part of the query?

Joe Easley

office: 704-808-7449

mobile: 803-322-0520

email: joeeasley@odysseylogistics.com<mailto:joeeasley@odysseylogistics.com>

[stabben23]

LOAD *

from lib://blablabla\OnBase_BATCHDATA.......aso.qvd

where Exists( BATCHNUM);

LOAD *

from lib://blablabla\OnBase_NOTES.......aso.qvd

where Exists( ITEMNUM);

[stabben23]

Or you can use:

LEFT KEEP (ONBASEITEM) LOAD