Incremental Load of excel files using timestamps

[vikasmahajan]

Hi Team,

Please find attached QVW file.  I have 2 excel files in feature it may be 12 or 13 .. etc  , I want to achieve the following things

- Creation of QVD  all excel files from folder with filename & Timestamps - > Achieved

- Loop  all excel files and check whether new excel file is available in folder if yes upload it  -> Achieved

- Loop all  excel file and check whether file is modified ?  if yes - > Delete all records from

                                                            QVD and take latest data from excel file                              - >  Require Help

I have attached qvw file also any one please help in this qvw.

I want to compare timestamps of existing excel file data from qvd and modified files from folder if found changed then delete data from QVD and take latest data into qvd.

I have attached sample excel files also.

Vikas

[MayilVahanan · Accepted solution]

Yes

[vikasmahajan]

Thanks Works...

Vikas

[vikasmahajan]

can you please explain  this line

If(FileTime - ApplyMap('Map_FileDetails', FileName, 0) > 0, 1, 0) AS  Flag; 

    FileTime-  ?

Vikas

[vikasmahajan]

can you please explain  this line

If(FileTime - ApplyMap('Map_FileDetails', FileName, 0) > 0, 1, 0) AS  Flag; 

    FileTime-  ?

Vikas

[MayilVahanan]

Hi

If(FileTime - ApplyMap('Map_FileDetails', FileName, 0) > 0, 1, 0) AS  Flag;

It subtract the current file time  and already created time. If it is same, then no need to proceed with that file.

By help of ApplyMap function, am achieving that.

[vikasmahajan]

ok Got it thanks

Vikas

[Drewster]

Hi i do not see the samples file as i am currently looking to explore this solution