topic storing by fields in QlikView https://community.qlik.com/t5/QlikView/storing-by-fields/m-p/209655#M64564 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I want to store just a few fields of a table</P><P></P><P></P><P></P><P></P><BR /><BR /> <P></P><P></P><P></P><P></P><P></P><P></P><P></P><BR /><BR /> <P></P><P></P><P style="font-weight: bold"></P><P style="font-weight: bold"></P>STORE<BR /><BR /> <P>STORE</P><P></P><P>/%Clave,</P><P>TAFMOD, TAICCL, TAIFME, TAIINC, TAINDO, TAISOC, TAISUC, TAITDO, TAITTL, TAIUSR, TAUSRA,</P><P>%ClaveCircularCLDCCL as FECHABORRADO</P><P></P><BR /><BR /> <P style="font-weight: bold"></P><P style="font-weight: bold">FROM</P><BR /><BR /> <P></P><P>CLDCCL</P><P></P><P></P><P></P><BR /><BR /> <P></P><P style="font-weight: bold"></P><P style="font-weight: bold">INTO</P><P></P><BR /><BR /> <P>CLDCCL.QVD;</P><P>and for some reason it doesn't work. I don't se the mistake. Can somebody tell me why the execution fail?</P><P></P><P>Many thanks</P></BODY></HTML> Mon, 20 Sep 2010 16:21:03 GMT 2010-09-20T16:21:03Z storing by fields https://community.qlik.com/t5/QlikView/storing-by-fields/m-p/209655#M64564 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I want to store just a few fields of a table</P><P></P><P></P><P></P><P></P><BR /><BR /> <P></P><P></P><P></P><P></P><P></P><P></P><P></P><BR /><BR /> <P></P><P></P><P style="font-weight: bold"></P><P style="font-weight: bold"></P>STORE<BR /><BR /> <P>STORE</P><P></P><P>/%Clave,</P><P>TAFMOD, TAICCL, TAIFME, TAIINC, TAINDO, TAISOC, TAISUC, TAITDO, TAITTL, TAIUSR, TAUSRA,</P><P>%ClaveCircularCLDCCL as FECHABORRADO</P><P></P><BR /><BR /> <P style="font-weight: bold"></P><P style="font-weight: bold">FROM</P><BR /><BR /> <P></P><P>CLDCCL</P><P></P><P></P><P></P><BR /><BR /> <P></P><P style="font-weight: bold"></P><P style="font-weight: bold">INTO</P><P></P><BR /><BR /> <P>CLDCCL.QVD;</P><P>and for some reason it doesn't work. I don't se the mistake. Can somebody tell me why the execution fail?</P><P></P><P>Many thanks</P></BODY></HTML> Mon, 20 Sep 2010 16:21:03 GMT https://community.qlik.com/t5/QlikView/storing-by-fields/m-p/209655#M64564 2010-09-20T16:21:03Z storing by fields https://community.qlik.com/t5/QlikView/storing-by-fields/m-p/209656#M64565 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>You may do a load of those fields you want to store in a different table, then store the complete table:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">ToFile:LOAD Field1, Field2 RESIDENT OriginalTable; STORE ToFile INTO FILE.QVD;DROP TABLE ToFile;</PRE></BLOCKQUOTE><BR /><BR /> <P>Hope that helps.</P></BODY></HTML> Mon, 20 Sep 2010 16:28:19 GMT https://community.qlik.com/t5/QlikView/storing-by-fields/m-p/209656#M64565 Miguel_Angel_Baeyens 2010-09-20T16:28:19Z