topic Re: Why records duplicated in QlikView https://community.qlik.com/t5/QlikView/Why-records-duplicated/m-p/1332733#M827992 <HTML><HEAD></HEAD><BODY><P>You are probably missing an additional key field with IntervalMatch(), maybe constructed using JobNo and DateFinalStatus:</P><P></P><P><A href="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/IntervalMatch_(Extended_Syntax).htm" title="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/IntervalMatch_(Extended_Syntax).htm">IntervalMatch (Extended Syntax) ‒ QlikView</A></P></BODY></HTML> Wed, 05 Jul 2017 13:57:44 GMT swuehl 2017-07-05T13:57:44Z Why records duplicated https://community.qlik.com/t5/QlikView/Why-records-duplicated/m-p/1332732#M827990 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P></P><P>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)</P><P></P><P><IMG alt="66.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/169190_66.png" style="height: auto;" /></P><P>I added row no for the show the duplication </P><P></P><P>i attached sample PFA</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Why-records-duplicated/m-p/1332732#M827990 vengadeshpalani 2020-11-25T16:16:04Z Re: Why records duplicated https://community.qlik.com/t5/QlikView/Why-records-duplicated/m-p/1332733#M827992 <HTML><HEAD></HEAD><BODY><P>You are probably missing an additional key field with IntervalMatch(), maybe constructed using JobNo and DateFinalStatus:</P><P></P><P><A href="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/IntervalMatch_(Extended_Syntax).htm" title="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/IntervalMatch_(Extended_Syntax).htm">IntervalMatch (Extended Syntax) ‒ QlikView</A></P></BODY></HTML> Wed, 05 Jul 2017 13:57:44 GMT https://community.qlik.com/t5/QlikView/Why-records-duplicated/m-p/1332733#M827992 swuehl 2017-07-05T13:57:44Z Re: Why records duplicated https://community.qlik.com/t5/QlikView/Why-records-duplicated/m-p/1332734#M827993 <HTML><HEAD></HEAD><BODY><P>Try with DISTINCT</P><P></P><P><STRONG>BridgeTable: </STRONG></P><P><STRONG>IntervalMatch (Date)</STRONG></P><P><STRONG>Load DISTINCT FromDate,</STRONG></P><P><STRONG>ToDate</STRONG></P><P><STRONG>resident TempFact;</STRONG></P></BODY></HTML> Wed, 05 Jul 2017 13:59:48 GMT https://community.qlik.com/t5/QlikView/Why-records-duplicated/m-p/1332734#M827993 sunny_talwar 2017-07-05T13:59:48Z Re: Why records duplicated https://community.qlik.com/t5/QlikView/Why-records-duplicated/m-p/1332735#M827994 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Wed, 05 Jul 2017 14:07:16 GMT https://community.qlik.com/t5/QlikView/Why-records-duplicated/m-p/1332735#M827994 Anonymous 2017-07-05T14:07:16Z