I have a daily CSV file and I'm trying to create a history file based on the records that are in "Yesterday's file" but not in "today's file". To do that I'm trying to get the difference between yesterday's file and today's file. Whatever is in yesterday's file but not in today's file I'll save in a separate QVD. Concatenate it with my results from before yesterday's results.
My yesterday's file is already in a QVD and my today's file is still in CSV format. So, what I'm trying to do is to load both, my QVD and my CSV into a QVW and manipulate it to get the difference between both.
Here is an ideas I got from the community but is not working for me yet.