Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Creator III
Creator III

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

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.

Highlighted
Specialist
Specialist

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

Hi Madhu,

Maybe this link can help you.

Incremental Load in Qlikview - Sources

Regards

Miguel del Valle

Highlighted
Champion
Champion

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

Exact requirement done here Incremental Load using Timestamps Multiple Excel

Vikas

Highlighted

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

Highlighted

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

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)