Discussion board where members can get started with QlikView.
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
Try with DISTINCT
Load DISTINCT FromDate,
View solution in original post
You are probably missing an additional key field with IntervalMatch(), maybe constructed using JobNo and DateFinalStatus:
IntervalMatch (Extended Syntax) ‒ QlikView
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.