How to load database tables dynamically using metadata ?

Tue, 11 Aug 2009 22:35:12 GMT

I would like to load database tables into qlikview dependent on the metadata of that database.

I want to load the metadata into an internal qlikview table and than loop through the internal qlikview table with the metadata.

How can I achieve this. This must be done during the reload.

I have written some pseudo code below

//Load Metadata

LOAD TableNames

FROM MetadataTable

WHERE ...

;

Tue, 11 Aug 2009 22:36:31 GMT

// Loop through Tablenames

FOR EACH vTableName in MetadataTable. TableNames

LOAD * FROM $(vTableName);

Next vTableName

;

topic How to load database tables dynamically using metadata ? in QlikView