4 Replies Latest reply: Jun 2, 2017 9:11 AM by Staffan Johansson RSS

    WHERE clause on QVD load

    Joe Easley

      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?

      tables.jpgscript.png