Add latest Data from several Files

[dominik_m_]

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???

[shiveshsingh]

What is the logic of old and New?

[dominik_m_]

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.