topic Checking all qvds are present before loading in QlikView

Checking all qvds are present before loading

mrooney — Thu, 28 Aug 2014 16:52:22 GMT

Hi,

here a llitle script to make sure all your qvd are in place before going ahead with the whole script. Mey be it is not optim and you might want to improve it a bit.

Hope it's useful

Re: Checking all qvds are present before loading

Thu, 28 Aug 2014 17:44:36 GMT

Thanks -Ram

Re: Checking all qvds are present before loading

Thu, 28 Aug 2014 17:53:13 GMT

You can use Inline table as

Input_Tables:

Load * inline [

Tables

Aqua85.qvd

Sales.qvd

Shipments.qvd

] (Delimiter is '|');

and

Let vFieldCount = FieldValueCount('Tables');

instead of hard coding the file nos. as 3.

Anyways, Your code was very useful and used with little bit clean up.

-Ram

Re: Checking all qvds are present before loading

Thu, 28 Aug 2014 17:53:27 GMT

Good!!

Re: Checking all qvds are present before loading

mrooney — Thu, 28 Aug 2014 17:59:06 GMT

Hi ramko496.

U are totally right. Is far clean your way.

Thanks.