Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
QvdNoOfRecords ('MyFile.qvd')
See the Ref Guide section "File Functions" for a complete list of functions you can use with QVDs.
-Rob
may be like this you want
Load
fld1,
fld2,
fld3,
rowno() as row
from yourqvd
Hi,
Use some thing
LOAD
ColA,
Recno() as RecId
FROM
QVDFile.qvd
(qvd);
Rgds
Anand
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
Hi,
See the sample file there i use Recno() as RecId.
Rgds
Anand
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
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
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
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
QvdNoOfRecords ('MyFile.qvd')
See the Ref Guide section "File Functions" for a complete list of functions you can use with QVDs.
-Rob