topic Re: WHERE clause on QVD load in App Development

WHERE clause on QVD load

jheasley — Fri, 02 Jun 2017 12:34:12 GMT

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?

Re: WHERE clause on QVD load

stabben23 — Fri, 02 Jun 2017 12:57:34 GMT

Hi,

like this:

where Exists( ITEMNUM) in Your ONBASENOTES table

where Exists( BATCHNUM) in Your ONBASEBATCHES table

Re: WHERE clause on QVD load

jheasley — Fri, 02 Jun 2017 13:00:44 GMT

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>

Re: WHERE clause on QVD load

stabben23 — Fri, 02 Jun 2017 13:09:14 GMT

LOAD *

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

where Exists( BATCHNUM);

LOAD *

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

where Exists( ITEMNUM);

Re: WHERE clause on QVD load

stabben23 — Fri, 02 Jun 2017 13:11:03 GMT

Or you can use:

LEFT KEEP (ONBASEITEM) LOAD