Hi Kushal,
Thanks for your support.
i got the output. i have used this code
for each Vpeek in FileList('H:\Personal\LATEST QVD\source1\*.xlsx');
let VRep=Replace(Vpeek,'.xlsx','.qvd');
T1:
LOAD*
FROM
[$(Vpeek)]
(ooxml, embedded labels, table is Sheet1);
STORE T1 into $(VRep);
drop table T1;
next
for each Vpeek1 in FileList('H:\Personal\LATEST QVD\source2\*.xlsx');
let VRep1=Replace(Vpeek1,'.xlsx','.qvd');
T4:
LOAD *
FROM
[$(Vpeek1)]
(ooxml, embedded labels, table is Sheet1);
STORE T4 into $(VRep1);
drop table T4;
next
LET vSource1Path ='H:\Personal\LATEST QVD\source1\';
LET vSource2Path ='H:\Personal\LATEST QVD\source2\';
LET vStorePath ='H:\Personal\LATEST QVD\';
For each vFile1 in Filelist ('$(vSource1Path)*.qvd')
Files1:
LOAD SubField('$(vFile1)','\',-1) as FileName,
'$(vFile1)' as FileName1,
filetime('$(vFile1)') as FileTime1
autogenerate 1;
Next vFile1
For each vFile2 in Filelist ('$(vSource2Path)*.qvd')
Files2:
LOAD SubField('$(vFile2)','\',-1) as FileName,
'$(vFile2)' as FileName2,
filetime('$(vFile2)') as FileTime2
autogenerate 1;
Next vFile2
New:
noconcatenate
LOAD *
Resident Files1;
inner join(New)
LOAD *
Resident Files2;
Drop Tables Files1, Files2;
FileName:
LOAD *
Where not IsNull(FileName);
LOAD
if(FileTime2 > FileTime1,FileName2,FileName1) as FileName,
timestamp(Rangemax(FileTime2,FileTime1)) as FileTime
Resident New;
DROP Table New;
AllQVD:
LOAD 1 as Junk
Autogenerate 1;
For i=1 to FieldValueCount('FileName')
let vFileName = FieldValue('FileName',$(i));
Concatenate(AllQVD)
LOAD *,
'$(vFileName)' as FileName
FROM $(vFileName)(Qvd);
Next i
drop field Junk;
Store AllQVD into $(vStorePath) FinalQVD.qvd;
Regards,
Mahesh.
