Reading QVDs from multiple directories

[#1]

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

[martin59]

Try this :

NAMES:
LOAD * FROM $(Dir)NAMES.qvd (qvd);

[#3]

I tried $(Dir), but still same issue.

Thanks

[#4]

did u try removing the spaces(before and after) in the first variable used for root dir?

[#5]

yes, the spaces are removed