Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Scenario:
I am having 6 QVD's
P_Employee.QVD
P_Customer.QVD
P_Vendor.QVD
P_Sales.QVD
P_CustomerContact.QVD
I want to load all QVD's but without loading a specific QVD in a folder (i.e. P_Vendor.QVD). for this, I wrote a code given below:
LOAD *
FROM
$(RawQvdPath)\P*.QVD
(qvd) Where FileName() <> 'P_Vendor.QVD';
The problem:
I am able to see it in the Table Viewer. Please suggest, how i make QV doesn't consider it.
Regards,
Try this approach:
for each File in filelist ('$(RawQvdPath)\*.qvd')
LET vTableName = Subfield(Subfield('$(File)', '\', SubstringCount('$(File)', '\') + 1), '.', 1);
if $(vTableName) <> "P_Vendor" then
$(vTableName):
LOAD * FROM $(File) (QVD);
end if
nextFile
Regards