Create Load Statement from SQL Schema Definition

Anonymous — Thu, 03 Oct 2013 17:44:51 GMT

I have a large number of tables that I want to generate Load script for as opposed to manually writing the script for each table. I have retrieved the table names and column names from SQL as illustrated below:

I would like to generate a script file that looks like:

AccountCombos:

Load PK,

... REMAINING COLUMNS ... ;

SELECT SQL

... COLUMN LIST ;

From AccountCombos;

Store AccountCombos into ../qvd/AccountCombox.qvd(qvd);

drop table accountCombos;

Re: Create Load Statement from SQL Schema Definition

Gysbert_Wassenaar — Thu, 03 Oct 2013 18:05:31 GMT

For SQL Server there's an extractor .qvw app available. It shouldn't be too hard to adapt it for other sql databases. Especially if you already have the schema data available.

topic Re: Create Load Statement from SQL Schema Definition in QlikView

Create Load Statement from SQL Schema Definition

Re: Create Load Statement from SQL Schema Definition