Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

nilesh_gangurde
Valued Contributor

.QVW to .CSV file

Hii All,

we can export the data from QVW file. but i need to export millions of record from the specific data model.

please share the fastest way to export the millions of records from .QVW file to the .csv File.

any suggetion will be appreciate.

-Nilesh

6 Replies
suniljain
Honored Contributor

Re: .QVW to .CSV file

you can use QVX in that case.

p_verkooijen
Valued Contributor

Re: .QVW to .CSV file

U can store tables into csv from the script use:

STORE data INTO data.csv (txt, delimiter is ';' );

nilesh_gangurde
Valued Contributor

Re: .QVW to .CSV file

I possible please provide the details.

-Nilesh

Not applicable

Re: .QVW to .CSV file

Hi Try this,

 

STORE

Field 1, Field 2   from Tablename INTOC:/MTDSales.csv(txt);

Selva

p_verkooijen
Valued Contributor

Re: .QVW to .CSV file

Sorry Nilesh, what details are you referring to ?

nilesh_gangurde
Valued Contributor

Re: .QVW to .CSV file

Hiii Paul,

I need to take data from multiple tables. or you can say i need to extract data from specific data model.

how we can do this ??.

the above store command will store data from only one month.

-Nilesh

Community Browser