I understand that's the issue is the group load of n QVD using * in the filename, when all the QVD have not the same number of fields.
- do 2 steps of load, 1 for the dates prior to January 30th and 1 for dates after, but you can't use * in the file name so.
- do a loop on the files and concatenate the content, then you won't have error. You can fill a missing field with "NullAsValue 'FIELDNAME'; Set NullValue = 0;" before the load and "NullAsNull 'FIELDNAME';" after.
The following script will assign NULL to missing values
Set vConcatenate = ;
for each vFile in FileList('MYDATA_*.qvd')
LOAD * FROM [$(vFile)] (qvd);
Set vConcatenate = Concatenate;
If you really want zero in missing values instead, then you can do it by looping over dates instead. Wildcards in the filename works, but is not as flexible as a real for – next loop.