topic Re: Compare qvd's. in QlikView

Compare qvd's.

Wed, 11 Apr 2012 12:37:24 GMT

Is there a way to compare qvds? In other words I have Groups_US and Groups_UK and want to see if they have the same fields and if not, what fields are different. Thanks.

Compare qvd's.

rbecher — Wed, 11 Apr 2012 14:55:18 GMT

Hi,

you can load the meta data from the QVD's XML header as a XML source into a QlikView table and display the differences then.

- Ralf

Re: Compare qvd's.

Wed, 18 Jul 2012 06:41:18 GMT

Hi Ralf

I followed the below steps to achieve the above but got stuck in below point. Could you please helpme out to proceed further?

Edit Script --> Table files --> Select the QVD --> File Type as Xml --> ???(What to be done after this?)

Also my situation is different here. Instead of comparing which fields are missing in the two similar QVD's I would like to know which records are missing in the two similar QVD's.

Please reply me back in your convenient time!

Thanks,
Attitude

Re: Compare qvd's.

rbecher — Wed, 18 Jul 2012 10:40:07 GMT

To load the table and field header of the QVD you can use this code (from TIQView):

QvdFieldHeader:

LOAD Left(FileName(), len(FileName())-4) as QVDName, RecNo() as FieldNo, *;

LOAD FieldName,

BitOffset,

BitWidth,

Bias,

NoOfSymbols,

Offset,

Length,

[NumberFormat/Type] as Type,

[NumberFormat/nDec] as nDec,

[NumberFormat/UseThou] as UseThou,

[NumberFormat/Fmt] as Fmt,

[NumberFormat/Dec] as Dec

FROM $(vQvdFile) (XmlSimple, Table is [QvdTableHeader/Fields/QvdFieldHeader]);

QvdTableHeader:

LOAD Left(FileName(), len(FileName())-4) as QVDName, *;

LOAD QvBuildNo,

CreateUtcTime,

SourceFileSize,

TableName,

RecordByteSize,

NoOfRecords,

Offset as HeaderOffset,

Length as HeaderLength

FROM $(vQvdFile) (XmlSimple, Table is [QvdTableHeader]);

How you will compare records? Do you have a primary key value to check existence of records?

- Ralf