Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
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.
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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)