How to get rowcount from a QVD file

[#1]

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

[SunilChauhan]

may be like this you want

Load

fld1,

fld2,

fld3,

rowno() as row

from yourqvd

[its_anandrjs]

Hi,

Use some thing

LOAD

ColA,

Recno() as RecId

FROM

QVDFile.qvd

(qvd);

Rgds

Anand

[GabrielAraya]

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

[its_anandrjs]

Hi,

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

Rgds

Anand

[its_anandrjs]

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

[#7]

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

[its_anandrjs]

Hi,

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

Like

Load

*,

Recno() as RecId

From QVD

Where Year = 2010;

and

20092010,2011 etc so on

HTH

Rgds

Anand

[GabrielAraya]

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

[rwunderlich · Accepted solution]

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