Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
dominik_m_
Creator
Creator

Add latest Data from several Files

Hi there,

I have a column that is fed by a new Excel File every week. The Excel Files are loaded with a Greencard * that is loading alway the latest Version of the file. Now the problem is that I'd like to keep the old data and change only the new one.

For example:
File 24 contains 1,1,1,0,0,0,1,1,1
File 25 contains 1,0,0,1,1,0,0,1,0
File 26 contains 1,1,1,0,0,1,1,0,1

With the normal load I get this result:
3,2,2,1,1,1,2,2,2

What I want is:
1,1,1,1,1,1,1,1,1

Anyone has an idea???

Labels (1)
2 Replies
shiveshsingh
Master
Master

What is the logic of old and New?

dominik_m_
Creator
Creator
Author

The tables contain daily hotelroom prices in a Benchmark forecast. So they change daily. After one day is done, the next file has a 0 on the day before but I'd like to have the last Price from the last file in it.
Right now I have the 'Replace' command running but it overwrites all data that I can only see the data from the latest file.