topic Re: Conditional - Loading in QlikView

Conditional - Loading

Thu, 10 Jan 2013 01:32:42 GMT

Hi Guys,

Hope you can help me.

I have this LOAD scripts:

SP:

LOAD * FROM Salesperson.qvd (QVD);

STORE SP INTO SP.QVD;

DROP TABLE SP;

INV:

LOAD * FROM Invoices.qvd (QVD);

STORE INV INTO INV.QVD;

DROP TABLE INV;

Currently they are stored in two separate QVW because of the reloading frequency.

Salesperson is reloaded every 7AM only, while

Invoices are reloaded every 1 Hour.

Is there a way to put this two in one QVW and do a conditional reload?

Say

IF Time is 7AM reload Salesperson

....

Thanks and regards,

~skip

Re: Conditional - Loading

nagaiank — Thu, 10 Jan 2013 02:35:12 GMT

Is there any advantage in having one qvw file instead of two?

If you are going to define QV Publisher tasks to load the two tables, having two qvw files is better as you can schedule the load tasks individually at different cycles.

Re: Conditional - Loading

Thu, 10 Jan 2013 02:38:28 GMT

I'm considering not the advantage of having one QVW but rather disadvantage of having multiple QVW.

I find troublesome to edit different qvw if I need to change them rather than in one QVW.