Solved: Excel file updation using timestamps - Page 3 - Qlik Community

vikasmahajan · ‎2016-02-08

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

vikasmahajan · ‎2016-02-09

Hi Pradeep,

My files could have 1 or 2 please suggest me changes in script .

File Name: AssetTrackingAug2; SheetName: AugInv2

File Name: AssetTrackingSep2; SheetName: SepInv2

Thanks

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

PradeepReddy · ‎2016-02-10

u need to change the 'vSheetName' logic.. in 2 places..

only these 2 formats, or trying to make generic..?

vikasmahajan · ‎2016-02-10

yes i want dynamic

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

vikasmahajan · ‎2016-02-10

Hi Pradeep,

In second condition when qvd exists and check for modification time (Timestamp) of existing file vs Excel file I am

getting problem.

I have 2 (Aug &Dec) files then i run your script first loop is ok qvd is created. But when i done some changes

in month of dec excel file and saved. when i run script again it loading 2 files it should run only dec file becuase i got modification in dec file only.

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

PradeepReddy · ‎2016-02-10

I will check and get back to you..

PradeepReddy · ‎2016-02-10

Hi Vikas,

I have misplaced the time checking logic. Now I modified the same and working as expected. See the attachment.

While reading the data from files, I changed the logic to generic. File Names/Sheet Names should be in bellow format only

File Name: AssetTrackingAug2; SheetName: AugInv2

File Name: AssetTrackingAug01; SheetName: AugInv01

File Name: AssetTrackingSep1; SheetName: SepInv1

File Name: AssetTrackingOct02; SheetName: OctInv02

Thanks,

Pradeep