now I have built a qvw that will load that data and be scheduled to run everyday and collect the previous days data "sysdate-1"
essentially what I would like to do is only update the current data with the previous days data every day
running that today would be fine I would have the last 100 days of data and yesterdays data, but if I had to reload tomorrow I would lose yesterdays data in tomorrows model. I understand I could store the "sysdate-1" data into a qvd as well but when reloading it the qvd will also be overwritten, how could I store the "sysdate-1" data into the qvd everyday without overwriting the previous days data?
