Why records duplicated

[vengadeshpalani]

Hi all

by using of autonumber function i map two fields, original record is near to 320000 when i store in to qvd it duplicated (it has 4.5GB)

I added row no for the show the duplication

i attached sample PFA

[swuehl]

You are probably missing an additional key field with IntervalMatch(), maybe constructed using JobNo and DateFinalStatus:

IntervalMatch (Extended Syntax) ‒ QlikView

[sunny_talwar · Accepted solution]

Try with DISTINCT

BridgeTable:

IntervalMatch (Date)

Load DISTINCT FromDate,

ToDate

resident TempFact;

[Anonymous]

Your Tempfact Join is not necessary.in line 20. This creates a table within a table. Like a forced join. and an Interval ID which you mentioned in the TempFact table in the beginning already.