topic Re. :Reading QVDs from multiple directories in QlikView

Reading QVDs from multiple directories

Mon, 10 Jan 2011 11:37:33 GMT

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

Re. :Reading QVDs from multiple directories

martin59 — Mon, 10 Jan 2011 12:12:58 GMT

Try this :


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

Re. :Reading QVDs from multiple directories

Mon, 10 Jan 2011 12:24:24 GMT

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

Thanks

Re. :Reading QVDs from multiple directories

Mon, 10 Jan 2011 12:41:10 GMT

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

Re. :Reading QVDs from multiple directories

Mon, 10 Jan 2011 13:00:32 GMT

yes, the spaces are removed