Hi,
I was wondering on the best way to set this up. Let me explain how the data is structured then what i want to do.
So in a database we have information structured like this
Date Name Sales
6/22/2018 John 1000
6/22/2018 Sam 2000
6/22/2017 Joan 1000
6/23/2018 John 1500
6/23/2018 Sam 2500
That is currently in out database. Tomorrow 6/24 info will be populated.
I have an extract loading in each file for 6/22, then 6/23 then i would need 6/24
Tomorrow when this data is captured a qvd called sales_6242018 will be created.
I do not want to reload, and do formulas on 6/22 or 6/23.
What would the proper way of loading just 6/24 info in?
