topic How to get rowcount from a QVD file in QlikView

How to get rowcount from a QVD file

Fri, 30 Sep 2011 14:29:33 GMT

Hello everyone,

I´m a newest in Qlikview world.

I need to get a rowcount from QVD file. How can help me?

Best regards

Joao

How to get rowcount from a QVD file

SunilChauhan — Fri, 30 Sep 2011 14:33:18 GMT

may be like this you want

Load

fld1,

fld2,

fld3,

rowno() as row

from yourqvd

How to get rowcount from a QVD file

its_anandrjs — Fri, 30 Sep 2011 14:37:00 GMT

Hi,

Use some thing

LOAD

ColA,

Recno() as RecId

FROM

QVDFile.qvd

(qvd);

Rgds

Anand

How to get rowcount from a QVD file

GabrielAraya — Fri, 30 Sep 2011 14:41:08 GMT

Hi,

You could try to read your QVD file as XML format ... one of the fields is NoofRecords ... If you read a QVD and add a field for example RowNo() or RecNo() you loose the optimized format ..
Gabriel

Re: How to get rowcount from a QVD file

its_anandrjs — Fri, 30 Sep 2011 14:41:23 GMT

Hi,

See the sample file there i use Recno() as RecId.

Rgds

Anand

How to get rowcount from a QVD file

its_anandrjs — Fri, 30 Sep 2011 14:56:02 GMT

Hi Gabriel,

I check it it shows exact records which is loaded like suppose there is 4 records so NoofRecords shows 4 exactly

Rgds

Anand

How to get rowcount from a QVD file

Fri, 30 Sep 2011 15:13:29 GMT

Hello friends,

Thank you by your replay.

But, my QVD file have amoung 2.000.000 and 3.000.000 rows and my memory crash when i LOAD ROWNO() AS ROW...

Have another way to read it?

Thanks

Re: How to get rowcount from a QVD file

its_anandrjs — Fri, 30 Sep 2011 15:15:26 GMT

Hi,

So in this case count it by Year or month wise and load data year wise or month wise.

Load

Recno() as RecId

From QVD

Where Year = 2010;

and

20092010,2011 etc so on

HTH

Rgds

Anand

How to get rowcount from a QVD file

GabrielAraya — Fri, 30 Sep 2011 15:17:15 GMT

Hi .. As I mencioned .. You can read a QVD file like a XML ..

QvdTableHeader:

LOAD QvBuildNo,

CreateUtcTime,

SourceFileSize,

TableName,

RecordByteSize,

NoOfRecords,

Offset,

Length,

%Key_QvdTableHeader_B94FCCAC68ED3E20 // Key for this table: QvdTableHeader

FROM C:\QlikTech\Proyectos\Cursos\Clientes.qvd (XmlSimple, Table is [QvdTableHeader]);

// End of [Clientes.qvd] LOAD statements

and the field NoOfRecords has the number of records in your QVD file

Re: How to get rowcount from a QVD file

rwunderlich — Fri, 30 Sep 2011 15:19:09 GMT

QvdNoOfRecords ('MyFile.qvd')

See the Ref Guide section "File Functions" for a complete list of functions you can use with QVDs.

-Rob

http://robwunderlich.com

How to get rowcount from a QVD file

Fri, 30 Sep 2011 16:13:17 GMT

Hello Gaa,

I´m try to use your script, but it´s running for 20 minutes.

Is it really slow?

Thank you