Excel file updation using timestamps

[vikasmahajan]

Dear all ,

I have 3 excel files , I stored into QVD (allqvd) .  Now if same name file with diff. timestamps file copied then existing data from allqvd should be deleted and new data from new excel file should appended in allqvd file.

Please share logic.

Thanks in adv.

Vikas

[sunny_talwar]

Not sure I completely understand what you are trying to do. Can you may be elaborate a little?

[vikasmahajan]

Hi Sunny ,

Thanks for reply,

I have 3 excel files I have made full data qvd stored into qvd and kept it.  Again suppose we received same 3 files with some modified records with different timestamps then I want to delete existing data from qvd for this 3 files and wants to append new data into full qvd file.

Hope you understand the requirement , Please let know if you require any thing.

This is urgent please give solution.

Thanks

Vikas

[HirisH_V7]

Hi,

Try Like this,

where Date(filetime(), 'DD/MM/YYYY') >= today()

For all of your Files such that you will get the data as of today() into your QVD.

HTH,

Hirish

[vikasmahajan]

do you have script ???

[avinashelite]

you could implement the Incremental loading concept rite? i.e. insert update and delete check the attached document

[HirisH_V7]

Hi,

Check this ,

PFA,

Hirish

[vikasmahajan]

Thanks for your reply Actually I want to store all data into qvd  and every time I want to update only latest modified file which will be possible through this script ?

Vikas

[vikasmahajan]

Requirement :

   1. I want to create fulldata qvd  store all excels file say 12 excel files.

   2. If user modify excel files and send for upload again then modified data should get updated

       and existing stored data should get deleted.

  3. if new file found append it .

Vikas

[manojkulkarni]

Hi Vikas,

I think you should go with Incremental Load logic. Please check the below link & third scenario might help

https://www.resultdata.com/three-types-of-qlikview-incremental-loads/