issue with multiple 'concatenate's (for incremental loading)
I have two tables and two qvds (say table1, table2 and qvd1,qvd2)
I am trying to concatenate the tables with respective qvds
But my problem is only first concatenate is working. The second concatenate, instead of concatenating (or appending), it is replacing the qvd2 with the table2 data. I thought there could be something wrong with the second concatenate statement. But when I swapped the statements like
Now the table2 and qvd2 concatenate is working fine but not the other one.
So I want to ask if anybody has tried using multiple concatenate statements and has anybody faced this kind of issue. Does anyone have a solution?
Re: issue with multiple 'concatenate's (for incremental loading)
Can you please help out in this case:
I have to concatenate the QVDs from different folders. But the problem is that, when the QVDs from 2nd folder are coming, they are replacing the QVDs generated from 1st folder. My aim is to concatenate the QVDs from both the folders. Please suggest. Do I need to mention CONCATENATE somewhere?
Below is my code:
set errormode = 0;
let qvdpath = 'C:\Users\DICKY\Desktop';
for each vPlant in '$(qvdpath)\MAP\' , '$(qvdpath)\HPG\'
for each qvd_file in FileList('$(vPlant)*')
let QVDName = subfield('$(qvd_file)','\',6);
store $(QVDName) into C:\Users\DICKY\Desktop\Test QVDs\$(QVDName);