Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to read similar QVDs from multiple directories using a FOR...EACH...NEXT but somehow its not working for me. Below is the directory structure:
Tables (root directory) -> Batch_A, Batch_B and Batch_C (sub directories)
Each of the above sub directory has following QVDs: Names.qvw, Fact_Sales.qvw and Fact_Commissions.qvw
I am trying to read Names.qvw from all three sub directories as below:
Set DataFileDir=" 'Tables' ";
FOR EACH Dir in dirlist ($(DataFileDir) &' \ ')
NAMES: LOAD * FROM [$(Dir)] NAMES.qvd (qvd);
NEXT Dir
But the above code is reading the data expected. Any help will be appreciated.
Thanks
Try this :
NAMES:
LOAD * FROM $(Dir)NAMES.qvd (qvd);
I tried $(Dir), but still same issue.
Thanks
did u try removing the spaces(before and after) in the first variable used for root dir?
yes, the spaces are removed