The below code works in loading new monthly QVDs but doesn't when new data needs to be added to already created monthly QVDs. What am I doing wrong in the "ELSE" part of the statement? Everything I've tried so far gets me the same results.
On a daily basis, I'm converting new .csv files into new .qvd files. All of the data from the .qvd files are then added to the Combined_Events.qvd file. From there, I want to create and update monthly .qvd files based on the EventMthYr. I have all of this working except for the updating of the monthly .qvd files.
Step 1: Convert daily .csv files to .qvd files // code working
Step 2: Create "Combined Events.qvd" // code working
On a daily basis, add new data to “Combined Events.qvd”. For each month year, pull those data rows and put into their own month year qvd (ex. “Combined Events – Jul 2015.qvd”). If data rows in “Combined Events.qvd” exist with EventMth = Aug 2015 but no “Combined Events – Aug 2015.qvd” exist, then create and populate the new qvd. If “Combined Events – Aug 2015.qvd” already exists, then add/concatenate the new data rows to the qvd.