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
Go to Solution.
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.