Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
Previously we have three qvd files QVDABCDev ,QVDABCQA , QVDABCProd in one folder so we were reading qvds as given below.
FOR Each files in FileList('$(vQVDPath)\QVDABC*.qvd')
now we have created separate folder for Dev/QA/Prod and placed QVDABCDev in Dev folder, QVDABCQA in QA folder and QVDABCProd in prod folder.
Now we want to change the above code so that it will go to each folder and read the qvd.
Please let us know any way to do it.
IF you have separate server paths store them into 3 individual variables and concatenate those QVDs accordingly.
Like
SET vQVDPath1 = 'YourDEVpath here\';
SET vQVDPath2 = 'YourQApath here\';
SET vQVDPath3 = 'YourPRODpath here\';
LOAD *
FROM $(vQVDPath1)\QVDABCDev.qvd(qvd);
CONCATENATE
LOAD *
FROM $(vQVDPath2)\QVDABCQA.qvd(qvd);
CONCATENATE
LOAD *
FROM $(vQVDPath3)\QVDABCProd.qvd(qvd);
If you want to look through the folders, you can use below sub routine to do that.
sub DoDir (Root)
for each Ext in 'qvd'
for each File in filelist (Root&'\*.'&Ext)
LOAD
'$(File)' as Name,
FileSize( '$(File)' ) as Size,
FileTime( '$(File)' ) as FileTime
autogenerate 1;
next File
next Ext
for each Dir in dirlist (Root&'\*' )
call DoDir (Dir)
next Dir
end sub
call DoDir ('C:')
Regards,
Kaushik Solanki