topic Re: Save qvd in QlikView https://community.qlik.com/t5/QlikView/Save-qvd/m-p/589865#M477280 <HTML><HEAD></HEAD><BODY><P>Use if NoOfRows before store table</P><P></P><P>Patricia</P></BODY></HTML> Wed, 07 May 2014 16:50:05 GMT 2014-05-07T16:50:05Z Save qvd https://community.qlik.com/t5/QlikView/Save-qvd/m-p/589863#M477278 <HTML><HEAD></HEAD><BODY><P>I have a list of 197 tables and I need to compare the different records. <BR />I'm using the command </P><P><BR />TbA:<BR />(select col_a, col_b, col_c<BR />&nbsp;&nbsp; from tab_1<BR /> union all<BR /> select col_a, col_b, col_c<BR />&nbsp;&nbsp; from tab_2)<BR />minus<BR />(select col_a, col_b, col_c<BR />&nbsp;&nbsp; from tab_1<BR /> intersect<BR /> select col_a, col_b, col_c<BR />&nbsp;&nbsp; from tab_2)</P><P><BR />TbB:<BR />(select col_a, col_b, col_c<BR />&nbsp;&nbsp; from tab_3<BR /> union all<BR /> select col_a, col_b, col_c<BR />&nbsp;&nbsp; from tab_4)<BR />minus<BR />(select col_a, col_b, col_c<BR />&nbsp;&nbsp; from tab_3<BR /> intersect<BR /> select col_a, col_b, col_c<BR />&nbsp;&nbsp; from tab_4)</P><P>etc...</P><P>When recording the QVD want it saved just Tb have different records, in the amount of TBA records read is 0 QVD not save ... <BR />Can anyone help?</P></BODY></HTML> Fri, 02 May 2014 15:00:53 GMT https://community.qlik.com/t5/QlikView/Save-qvd/m-p/589863#M477278 2014-05-02T15:00:53Z Re: Save qvd https://community.qlik.com/t5/QlikView/Save-qvd/m-p/589864#M477279 <HTML><HEAD></HEAD><BODY><P>if TbA and TbB etc have the same columns, QV will auto concatenate them into only one table. </P></BODY></HTML> Fri, 02 May 2014 15:03:51 GMT https://community.qlik.com/t5/QlikView/Save-qvd/m-p/589864#M477279 giakoum 2014-05-02T15:03:51Z Re: Save qvd https://community.qlik.com/t5/QlikView/Save-qvd/m-p/589865#M477280 <HTML><HEAD></HEAD><BODY><P>Use if NoOfRows before store table</P><P></P><P>Patricia</P></BODY></HTML> Wed, 07 May 2014 16:50:05 GMT https://community.qlik.com/t5/QlikView/Save-qvd/m-p/589865#M477280 2014-05-07T16:50:05Z