topic Re: QVD Reader? in QlikView

QVD Reader?

Wed, 16 Jul 2014 21:47:03 GMT

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

Re: QVD Reader?

Siva_Sankar — Fri, 18 Jul 2014 03:01:54 GMT

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.

Re: QVD Reader?

Mon, 04 Aug 2014 23:03:07 GMT

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.

Re: QVD Reader?

cristian_av — Tue, 05 Aug 2014 01:48:42 GMT

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.

Re: QVD Reader?

cristian_av — Tue, 05 Aug 2014 01:49:34 GMT

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.

Re: QVD Reader?

senarath — Tue, 05 Aug 2014 03:31:03 GMT

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

Re: QVD Reader?

etl_tools — Fri, 28 Nov 2014 12:11:49 GMT

You can try our Advanced ETl Processor.

it can read QVD files