Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
madhubabum
Creator
Creator

How we can get last updated(newly added) file with filename?

Hi All,

I have 10 files in single folder, later on we are added multiple files.

Step 1: First we have to load 10 files in a QVD

Step 2: Based upon the filename , We have to concatenate the newly added files to the Existing QVD(Incremental Logic only)

How we can implement this scenario , Any Help ?

Regards,

Madhu

5 Replies
bindu_apte
Creator III
Creator III

Hi,

You can do like this:

1: .

Load A,

B,

C

from folder\*.xls;

2:

While loading itself you can concatenate the files and then store into one qvd.

migueldelval
Specialist
Specialist

Hi Madhu,

Maybe this link can help you.

Incremental Load in Qlikview - Sources

Regards

Miguel del Valle

vikasmahajan

Exact requirement done here Incremental Load using Timestamps Multiple Excel

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.
Anil_Babu_Samineni

Madhu,

As i know, We can get the last updated rows using Incremental load. But, i am not aware of how do we show the File name as well.

Brain to heard for first time, If you get this Please post here as you are using..

- Anil

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful