topic Re: Incremental Load Doubts in App Development https://community.qlik.com/t5/App-Development/Incremental-Load-Doubts/m-p/978847#M14142 <HTML><HEAD></HEAD><BODY><P>Neha,</P><P></P><P>you need to provide what incremental technique you are using and if you have a unique key or if this is the combination between different fields, as Daniel already stated normally this is done with a primary key, though I have seen cases where the primary key is only unique for one specific date, so this is <SPAN style="font-size: 11.0pt; font-family: 'Calibri',sans-serif;">determined by</SPAN> your setup </P></BODY></HTML> Thu, 29 Oct 2015 14:04:28 GMT ramoncova06 2015-10-29T14:04:28Z Incremental Load Doubts https://community.qlik.com/t5/App-Development/Incremental-Load-Doubts/m-p/978844#M14139 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Can anyone please tell me after incremental load how do we make sure data loaded is not duplicate ??</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Just wanted to know what kind of filters we put at our end to make sure redundant data is not loaded in incremental load?</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Thank You</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Neha Agrawal<BR /></SPAN></P></BODY></HTML> Wed, 28 Oct 2015 10:35:11 GMT https://community.qlik.com/t5/App-Development/Incremental-Load-Doubts/m-p/978844#M14139 2015-10-28T10:35:11Z Re: Incremental Load Doubts https://community.qlik.com/t5/App-Development/Incremental-Load-Doubts/m-p/978845#M14140 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>can anyone please answer this question....!!</P><P></P><P></P><P>Thank You</P><P>Neha Agrawal</P></BODY></HTML> Thu, 29 Oct 2015 07:04:21 GMT https://community.qlik.com/t5/App-Development/Incremental-Load-Doubts/m-p/978845#M14140 2015-10-29T07:04:21Z Re: Incremental Load Doubts https://community.qlik.com/t5/App-Development/Incremental-Load-Doubts/m-p/978846#M14141 <HTML><HEAD></HEAD><BODY><P>You usually use the primary key for that.</P><P></P><P>You load the incremental extract and then concatenate the data from previous extractions whose primary key has not been previously loaded in the incremental part.</P></BODY></HTML> Thu, 29 Oct 2015 13:49:10 GMT https://community.qlik.com/t5/App-Development/Incremental-Load-Doubts/m-p/978846#M14141 danielrozental 2015-10-29T13:49:10Z Re: Incremental Load Doubts https://community.qlik.com/t5/App-Development/Incremental-Load-Doubts/m-p/978847#M14142 <HTML><HEAD></HEAD><BODY><P>Neha,</P><P></P><P>you need to provide what incremental technique you are using and if you have a unique key or if this is the combination between different fields, as Daniel already stated normally this is done with a primary key, though I have seen cases where the primary key is only unique for one specific date, so this is <SPAN style="font-size: 11.0pt; font-family: 'Calibri',sans-serif;">determined by</SPAN> your setup </P></BODY></HTML> Thu, 29 Oct 2015 14:04:28 GMT https://community.qlik.com/t5/App-Development/Incremental-Load-Doubts/m-p/978847#M14142 ramoncova06 2015-10-29T14:04:28Z