multiple excels into qvd (Avoid reload of excel again)

[vikasmahajan]

Dear All

I have following code for getting all excel loaded into qlikview and create qvd  my problem is that if one excel is loaded already in qvd

who to skip that excel file for reloading again again is time consuming !

Set vPathXLS='\\inprgcfl06\HOME\Vikas\DataSources';

AsTrk:

Load

    *

, FileName() as FileName

From

[$(vPathXLS)\Asset*.xlsx]

(ooxml, embedded labels, table is [$(*)]);

Please advise

Thanks in adv.

Vikas

https://lh3.googleusercontent.com/-cGSYPnkvpuQ/AAAAAAAAAAI/AAAAAAAAAAA/FScqHBqttrY/s46-c-k-no/photo....

https://lh5.googleusercontent.com/-lJ_EqP6J25c/Vh6BdRKJ7EI/AAAAAAAACFw/WkUMdpFXR4s/w239-h425/IMG_201...

[Anonymous]

Hi Vikas,

does your excel filename has time stamp.

Regards

Neetha

[vikasmahajan]

Suppose I loaded  Asset1.xls , Asset2.xls , Asset3.xls  files and stored into asset.qvd

then who to check Asset1.xls,Asset2.xls & ....  is already loaded into asset.qvd ??

Vikas

[vikasmahajan]

Hi Neetha ,

My excel file name will be like this  Assetmay1.xls , Assetmay2.xls , Assetjun1.xls , ....

Vikas

[Anonymous]

Try to subfield Month part and create new field as Filemonth.

Load only files greater than max filemonth in QVD and concatenate with

data in QVD

[martin_dideriks]

This is the "easy" solution attached.

It simply checks your qvd file for already loaded files - you must, however include a "SourceFile" field.

You should consider using the filetime() for the files - then load all the files that has been updated since last reload.

This way, you will be able to update your excel file and afterwards update you qvd with the modified data.

//Martin

[SreeniJD]

Hi Vikas,

The easiest way is to have the qvd name similar to your filename along with the timestamp. which will definitely works.

Sreeni

[vikasmahajan]

Dear Martin,

Thanks for your reply,

Please can you tell me where I have to use the below script

Set vPathXLS='\\inprgcfl06\HOME\Vikas\DataSources';

AsTrk:

Load

    *

, FileName() as FileName

From 

[$(vPathXLS)\Asset*.xlsx]

(ooxml, embedded labels, table is [$(*)]);

Thanks

Vikas

[vikasmahajan]

Can you update please

Vikas

[vikasmahajan]

Dear Martin

Please find data with qvw please tell me where to incorporate your script now I have loaded Empdet1.xls,Empdet2.xls in qvd and stored it.

Suppose Emp3.xls is added so I want to load only Emp3.xls not Empdet1.xls and Empdet2.xls because this two are available in qvd.

Please Guide.

Vikas