topic Re: Problem with Duplicate records in QlikView https://community.qlik.com/t5/QlikView/Problem-with-Duplicate-records/m-p/922708#M652754 <HTML><HEAD></HEAD><BODY><P>Noted and Thanks Colin but present i don't have access the server once i get access definitely post the screenshots</P></BODY></HTML> Thu, 30 Jul 2015 16:26:32 GMT 2015-07-30T16:26:32Z Problem with Duplicate records https://community.qlik.com/t5/QlikView/Problem-with-Duplicate-records/m-p/922704#M652750 <HTML><HEAD></HEAD><BODY><P>Hi Buddy,</P><P>I have a table with 2918117 records. I converted database table in qvd when i'm check the raw data on a particular date the records are 6399.After i made some transformations i'll check the same date the record shows 90000+.Guys please help me why I'm getting like this.</P></BODY></HTML> Thu, 30 Jul 2015 16:20:10 GMT https://community.qlik.com/t5/QlikView/Problem-with-Duplicate-records/m-p/922704#M652750 2015-07-30T16:20:10Z Re: Problem with Duplicate records https://community.qlik.com/t5/QlikView/Problem-with-Duplicate-records/m-p/922705#M652751 <HTML><HEAD></HEAD><BODY><P>It would help if you posted your script or the changes you made that caused the record count to increase.</P></BODY></HTML> Thu, 30 Jul 2015 16:22:22 GMT https://community.qlik.com/t5/QlikView/Problem-with-Duplicate-records/m-p/922705#M652751 Colin-Albert 2015-07-30T16:22:22Z Re: Problem with Duplicate records https://community.qlik.com/t5/QlikView/Problem-with-Duplicate-records/m-p/922706#M652752 <HTML><HEAD></HEAD><BODY><P>It may be been caused to Cartesian product of you are doing a join before storing it into a qvd. I would investigate any join before storing it into a qvd. </P></BODY></HTML> Thu, 30 Jul 2015 16:25:59 GMT https://community.qlik.com/t5/QlikView/Problem-with-Duplicate-records/m-p/922706#M652752 sunny_talwar 2015-07-30T16:25:59Z Re: Problem with Duplicate records https://community.qlik.com/t5/QlikView/Problem-with-Duplicate-records/m-p/922707#M652753 <HTML><HEAD></HEAD><BODY><P>And probably use Mapping Loads wherever it is possible to use them.</P></BODY></HTML> Thu, 30 Jul 2015 16:26:19 GMT https://community.qlik.com/t5/QlikView/Problem-with-Duplicate-records/m-p/922707#M652753 sunny_talwar 2015-07-30T16:26:19Z Re: Problem with Duplicate records https://community.qlik.com/t5/QlikView/Problem-with-Duplicate-records/m-p/922708#M652754 <HTML><HEAD></HEAD><BODY><P>Noted and Thanks Colin but present i don't have access the server once i get access definitely post the screenshots</P></BODY></HTML> Thu, 30 Jul 2015 16:26:32 GMT https://community.qlik.com/t5/QlikView/Problem-with-Duplicate-records/m-p/922708#M652754 2015-07-30T16:26:32Z Re: Problem with Duplicate records https://community.qlik.com/t5/QlikView/Problem-with-Duplicate-records/m-p/922709#M652755 <HTML><HEAD></HEAD><BODY><P>I would agree with <A href="https://community.qlik.com/qlik-users/171708">sunindia</A>‌ that it is likely to be a join that is causing the increase.</P><P></P><P>As a general rule of thumb you do not need to make joins at all in your load script.&nbsp; You can simply keep the tables separate and allow associations to happen in the data model.</P><P></P><P>Using mapping loads are a good way of avoiding joins for simple lookup tables (but if duplicates are being caused mapping tables would not work as only one value would be mapped).</P><P></P><P>This article on mapping may be of interest to you:</P><P><A href="http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/" title="http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/">http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/</A></P><P></P><P>Steve</P></BODY></HTML> Thu, 30 Jul 2015 16:31:39 GMT https://community.qlik.com/t5/QlikView/Problem-with-Duplicate-records/m-p/922709#M652755 stevedark 2015-07-30T16:31:39Z Re: Problem with Duplicate records https://community.qlik.com/t5/QlikView/Problem-with-Duplicate-records/m-p/922710#M652757 <HTML><HEAD></HEAD><BODY><P>Further to Steve's post, this article on mapping tables is useful.</P><P><A href="https://community.qlik.com/qlik-blogpost/2756">Don't join - use Applymap instead</A></P></BODY></HTML> Thu, 30 Jul 2015 16:39:40 GMT https://community.qlik.com/t5/QlikView/Problem-with-Duplicate-records/m-p/922710#M652757 Colin-Albert 2015-07-30T16:39:40Z Re: Problem with Duplicate records https://community.qlik.com/t5/QlikView/Problem-with-Duplicate-records/m-p/922711#M652759 <HTML><HEAD></HEAD><BODY><P>Thanks guys for your support</P></BODY></HTML> Fri, 31 Jul 2015 09:33:40 GMT https://community.qlik.com/t5/QlikView/Problem-with-Duplicate-records/m-p/922711#M652759 2015-07-31T09:33:40Z