topic loading data from 2 qvd's in QlikView https://community.qlik.com/t5/QlikView/loading-data-from-2-qvd-s/m-p/259531#M97975 <HTML><HEAD></HEAD><BODY><P> Sorry it was quite easy using 'where not exists(ID)' so this is working now. thanks. </P></BODY></HTML> Thu, 02 Jun 2011 09:03:18 GMT 2011-06-02T09:03:18Z loading data from 2 qvd's https://community.qlik.com/t5/QlikView/loading-data-from-2-qvd-s/m-p/259530#M97974 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have 2 QVD's ( week &amp; month) which I want to consolidate in to one.</P><P></P><P>The only thing is there are records in both that have the same ID, the way it should work is to load everything from 'week' and only those from 'month' where the ID does not exist in 'week'.</P><P></P><P>I know there's an exists statement but not sure how to code it so that I achieve what I'm trying to do, if anyone can help it would be much appreciated.</P><P></P><P>Many thanks,</P><P>Phil</P></BODY></HTML> Thu, 02 Jun 2011 08:37:26 GMT https://community.qlik.com/t5/QlikView/loading-data-from-2-qvd-s/m-p/259530#M97974 2011-06-02T08:37:26Z loading data from 2 qvd's https://community.qlik.com/t5/QlikView/loading-data-from-2-qvd-s/m-p/259531#M97975 <HTML><HEAD></HEAD><BODY><P> Sorry it was quite easy using 'where not exists(ID)' so this is working now. thanks. </P></BODY></HTML> Thu, 02 Jun 2011 09:03:18 GMT https://community.qlik.com/t5/QlikView/loading-data-from-2-qvd-s/m-p/259531#M97975 2011-06-02T09:03:18Z