Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

jerryhnc
New 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

Re: Create Load Statement from SQL Schema Definition

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
Community Browser