Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
jerryhnc
Contributor III
Contributor III

Create Load Statement from SQL Schema Definition

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:

schema.png

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;

1 Reply
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand