Load script data from SQL and store them in an xls(x)

Thu, 11 Aug 2016 07:48:49 GMT

Hi,

we Need to prepare an ERP-Implementation and have some issues with exporting data into excel

Does someone of you knows a way to load data directly from the database and store them into an excelfile?

Today we are loading like below and it works.

Now we Need additionally a load into Excel.

But we have a second challenge: The first 60.000 entries go into Table 1, the next 60.000 entries go into Table 2 and so on

(If we create a table and Export to Excel it has more than 1.2 Million entries)

efa_asset:
LOAD
//Index der CODA-Tabelle
...
;
SQL SELECT *
FROM CODA."EFA_ASSET"
WHERE CMPCODE like '$(varCMPCODE_SQL)'
//AND DELDATE is null
;

store efa_asset into $(DirDataQVD)efa_asset.qvd; (This should be adapted to load it into an Excel-File)

Example:

store efa_asset into $(DirDataQVD)efa_asset.xlsx;

Re: Load script data from SQL and store them in an xls(x)

Gysbert_Wassenaar — Thu, 11 Aug 2016 08:03:49 GMT

You can't store to an excel file. Only output to qvd and text files (like csv) are possible.

store efa_asset into $(DirDataQVD)efa_asset.csv (txt, delimiter is ',');

If you need to dump data from a database directly from the database into excel files then use an ETL tool that supports writing to Excel.

topic Load script data from SQL and store them in an xls(x) in QlikView

Load script data from SQL and store them in an xls(x)

Re: Load script data from SQL and store them in an xls(x)