Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Limit to CSV export?

Hi,

I'm trying to export a straight table with 1,400,000 rows x 7 columns to CSV, but after 24 hours the QV.exe process is appearing as not responding and I can conclude the process failed.

I thought there was a limit to excel exporting, but there seems to be one for csv too. Any suggestions?

6 Replies
Luminary
Luminary

First suggestion: Don't!

If you absolutely must, I would pick a selector (week, month, etc.) and do a separate export for each selection and then combine the files in the file system.

Stephen

Partner
Partner

Or another idea is store it in QVD and make use of the fact that QVD is basically an XML file.

May be you can do conversion QVD -> CSV outside QlikView?

Luminary
Luminary

Hi Rakesh,

A QVD file is certainly not "basically an XML file". It has an XML header, but the data is bitcompressed. Good luck trying to extract it outside of QlikView.

Regards,

Stephen

Partner
Partner

You are right Stephan QVD is not "basically an XML file".

Then, may be converting QVD -> CSV can be taken offline in some kind of separate QVDtoCSV.qvw application, kind of out of "that" particular QlikView so user don't have to wait. Obviousely extracting those many records to CSV will surely have problems. But I am not expert of exporting to CSV either.

It would be nice to have a fast QVD -> CSV convertor, wouldn't it?

I wait for someone to suggest best possible solution on this one.

Not applicable

Hi guys,

Sorry to steal this thread, but my issue is very much related....

I now use:

TableName:

LOAD *





FROM (qvd);



Store TableName Into ;



DROP Table TableName;

I have 2 issues:

1) I'm limited to a certain amount of lines, so would like to export the table in sets of an x amount of rows. Would anyone know how to script this?

2) My txt (or csv) files all get XML headers and MS Access gets stuck on these when I try to load them. Is there a way to export without the XML format?

MVP & Luminary
MVP & Luminary

Did you try my app QVD2CVS?

http://community.qlik.com/media/p/94004.aspx

- Ralf

Vizlib Head of R&D