Incremental Load with Update not concatenating Historical Data
I have a problem which I cannot figure out. I wrote a test script which successfully does an incremental load on two manually typed Excel files with about 15 rows of data each by doing the following:
LOAD * FROM Incremental. QVD
CONCATENATE LOAD * FROM Historical.QVD where not exists(Date)
One data set time overlaps the other so the end result is a larger data set with prior values being changed. My real script uses the same general logic but my resulting data set is only the incremental load. My actual data files is an Access export with different date ranges in the query. I would assume its an inconsistency in the date format but that doesn't appear to be the case. I have tried formatting the timestamp in the resulting export as a serial and a short date but it still doesn't work. My sample files aren't sensitive to format changes. It is not concatenating the historical QVD.
Does anyone have an idea what could cause this? Thank you in advance.