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