Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

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

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;

1 Reply

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

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.


talk is cheap, supply exceeds demand
Community Browser