topic Drop table in QlikView https://community.qlik.com/t5/QlikView/Drop-table/m-p/706576#M254630 <HTML><HEAD></HEAD><BODY><P>goo day ,</P><P></P><P>Can you please explain me when and why to use drop table ?</P><P>for example this :</P><P></P><P style="color: #333333; font-family: Verdana, sans-serif; font-size: 13px; background-color: #e0e0e0;"><SPAN style="font-family: 'courier new'; font-size: 11.050000190734863px;">GREEN_SALES:<BR />//Sales of product made from recycled materials<BR />Load<BR />CUSTOMER,<BR />SALES_DATE,<BR />QUANTITY<BR />Resident 2009_SALES_DETAIL<BR />Where Exists(RECYCLE_PRODUCT,PRODUCT_CODE);</SPAN></P><P style="color: #333333; font-family: Verdana, sans-serif; font-size: 13px; background-color: #e0e0e0;"><SPAN style="font-family: 'courier new'; font-size: 11.050000190734863px;">Drop table TEMP_RECYCLE_PRODUCTS;</SPAN></P></BODY></HTML> Thu, 04 Sep 2014 06:54:47 GMT 2014-09-04T06:54:47Z Drop table https://community.qlik.com/t5/QlikView/Drop-table/m-p/706576#M254630 <HTML><HEAD></HEAD><BODY><P>goo day ,</P><P></P><P>Can you please explain me when and why to use drop table ?</P><P>for example this :</P><P></P><P style="color: #333333; font-family: Verdana, sans-serif; font-size: 13px; background-color: #e0e0e0;"><SPAN style="font-family: 'courier new'; font-size: 11.050000190734863px;">GREEN_SALES:<BR />//Sales of product made from recycled materials<BR />Load<BR />CUSTOMER,<BR />SALES_DATE,<BR />QUANTITY<BR />Resident 2009_SALES_DETAIL<BR />Where Exists(RECYCLE_PRODUCT,PRODUCT_CODE);</SPAN></P><P style="color: #333333; font-family: Verdana, sans-serif; font-size: 13px; background-color: #e0e0e0;"><SPAN style="font-family: 'courier new'; font-size: 11.050000190734863px;">Drop table TEMP_RECYCLE_PRODUCTS;</SPAN></P></BODY></HTML> Thu, 04 Sep 2014 06:54:47 GMT https://community.qlik.com/t5/QlikView/Drop-table/m-p/706576#M254630 2014-09-04T06:54:47Z Re: Drop table https://community.qlik.com/t5/QlikView/Drop-table/m-p/706577#M254631 <HTML><HEAD></HEAD><BODY><P>There are 2 tables, the <SPAN style="color: #333333; font-family: 'courier new'; font-size: 11px; background-color: #e0e0e0;">TEMP_RECYCLE_PRODUCTS</SPAN> table is a temporary one because it is used to filter the first table only with existing products. Once the filtering is ended the <SPAN style="color: #333333; font-family: 'courier new'; font-size: 11px; background-color: #e0e0e0;">TEMP_RECYCLE_PRODUCTS</SPAN> is deleted with a drop.</P></BODY></HTML> Thu, 04 Sep 2014 06:56:48 GMT https://community.qlik.com/t5/QlikView/Drop-table/m-p/706577#M254631 alexandros17 2014-09-04T06:56:48Z