Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

QVD Reader?

Hi,

I am trying to find a way to extract data from a large QVD file. The size of the QVD is 6.3GB. It contains over 170MM rows of data and about 30 columns. Any ideas?

Thank you,

Chris

Tags (2)
6 Replies
Siva_Sankar
Honored Contributor

Re: QVD Reader?

If there is any date column in the qvd file, try splitting the qvd for different years and extract the data. Or you can you try extracting the QVD with appropriate filters.

Or try using QViewer or advanced etl tools like qlikview expressor.

Not applicable

Re: QVD Reader?

I ended up just recreating the QVD as 11 TXT files of about 2/3GB each. I was looking for a tool but did not want to pay.

cristian_av
Contributor III

Re: QVD Reader?

Hi

I use QEye, I've never used it with a 6 Gb file.. but maybe the 64 bits version will work! (it's free)

This is the link where you can find it http://www.etl-tools.com/products/q-eye-overview.html

Hope it helps.

cristian_av
Contributor III

Re: QVD Reader?

Hi

I use QEye, I've never used it with a 6 Gb file.. but maybe the 64 bits version will work! (it's free)

This is the link where you can find it Q-Eye Freware QVD and QVX Viewer (64 bits!!)

Hope it helps.

senarath
Contributor III

Re: QVD Reader?

Hi,

Select only the columns that you really want to load as well. Also try to make use of group by or any other meaningful filtering option.

thanx

etl_tools
Contributor

Re: QVD Reader?

You can try our Advanced ETl Processor.

it can read QVD files

Community Browser