Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Yes
Thanks Works...
Vikas
can you please explain this line
If(FileTime - ApplyMap('Map_FileDetails', FileName, 0) > 0, 1, 0) AS Flag;
FileTime- ?
Vikas
can you please explain this line
If(FileTime - ApplyMap('Map_FileDetails', FileName, 0) > 0, 1, 0) AS Flag;
FileTime- ?
Vikas
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.
ok Got it thanks
Vikas
Hi i do not see the samples file as i am currently looking to explore this solution