Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
nilesh_gangurde
Partner - Specialist
Partner - Specialist

.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

Labels (1)
6 Replies
suniljain
Master
Master

you can use QVX in that case.

p_verkooijen
Partner - Specialist II
Partner - Specialist II

U can store tables into csv from the script use:

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

nilesh_gangurde
Partner - Specialist
Partner - Specialist
Author

I possible please provide the details.

-Nilesh

Not applicable

Hi Try this,

 

STORE

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

Selva

p_verkooijen
Partner - Specialist II
Partner - Specialist II

Sorry Nilesh, what details are you referring to ?

nilesh_gangurde
Partner - Specialist
Partner - Specialist
Author

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