topic Re: Add latest Data from several Files in Connectivity & Data Prep

Add latest Data from several Files

dominik_m_ — Mon, 13 Dec 2021 17:33:19 GMT

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

Re: Add latest Data from several Files

shiveshsingh — Wed, 03 Apr 2019 09:45:05 GMT

What is the logic of old and New?

Re: Add latest Data from several Files

dominik_m_ — Wed, 03 Apr 2019 09:55:05 GMT

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.