topic Re: delete row in QlikView https://community.qlik.com/t5/QlikView/delete-row/m-p/705171#M254245 <HTML><HEAD></HEAD><BODY><P>Hi, search for 'Using QVDs for incremental Load' in QV help (F11), to see different scenarios,</P><P></P><P></P><P>regards</P></BODY></HTML> Wed, 18 Jun 2014 16:01:06 GMT jaimeaguilar 2014-06-18T16:01:06Z delete row https://community.qlik.com/t5/QlikView/delete-row/m-p/705169#M254243 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>i have a basic database qvd. can i merge this database qvd with an actual qvd with only actual changes and merge this two tables and remove the lines in the basic databse which are still existing in both tables and after that i want to concanate the lines from the actual qvd with the changes in the basic database.</P><P></P><P>I hope its clear what i need... </P></BODY></HTML> Wed, 18 Jun 2014 15:41:57 GMT https://community.qlik.com/t5/QlikView/delete-row/m-p/705169#M254243 2014-06-18T15:41:57Z Re: delete row https://community.qlik.com/t5/QlikView/delete-row/m-p/705170#M254244 <HTML><HEAD></HEAD><BODY><P>Yes you can, If you have an ID field which is unique (and therefore duplicated) you can remove it be using:</P><P></P><P>Where not exists([ID Field])</P><P></P><P>in the load statement.</P><P></P><P>Regards</P><P></P><P>Richard</P><P>QlikCentral.com</P></BODY></HTML> Wed, 18 Jun 2014 15:55:27 GMT https://community.qlik.com/t5/QlikView/delete-row/m-p/705170#M254244 richard_pearce6 2014-06-18T15:55:27Z Re: delete row https://community.qlik.com/t5/QlikView/delete-row/m-p/705171#M254245 <HTML><HEAD></HEAD><BODY><P>Hi, search for 'Using QVDs for incremental Load' in QV help (F11), to see different scenarios,</P><P></P><P></P><P>regards</P></BODY></HTML> Wed, 18 Jun 2014 16:01:06 GMT https://community.qlik.com/t5/QlikView/delete-row/m-p/705171#M254245 jaimeaguilar 2014-06-18T16:01:06Z