topic How to Export Table and exclude Field Labels in QlikView https://community.qlik.com/t5/QlikView/How-to-Export-Table-and-exclude-Field-Labels/m-p/428744#M702600 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I'm trying to store data in a table into a text file, but i'm trying to leave out the labels as I only need the data (which will only ever be one field/row)</P><P></P><P>My Current code is as follows:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13482184833858859" jivemacro_uid="_13482184833858859"><P>NOCONCATENATE</P><P>EmailSubject:</P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp; LTRIM(MaxString(EmailSubjTmp)) as 'SubjectLine'</P><P>RESIDENT [TMPEmailSubject];</P><P></P><P>DROP TABLE TMPEmailSubject;</P><P></P><P><STRONG>STORE SubjectLine FROM EmailSubject INTO [EmailSubject.txt](txt, codepage is 1252, no labels, delimiter is '\n', no quotes);</STRONG></P></PRE><P></P><P>For some reason, in the STORE line, evey parameter after txt is normal text and not highlighted as usual....codepage for example shows up as an error when i do a syntax check.</P><P></P><P>My resulting file has in the first line 'SubjectLine' and on the second line is the data. I ONLY want the data.</P><P></P><P>Any help will be highly apprciated.</P></BODY></HTML> Fri, 21 Sep 2012 09:10:54 GMT 2012-09-21T09:10:54Z How to Export Table and exclude Field Labels https://community.qlik.com/t5/QlikView/How-to-Export-Table-and-exclude-Field-Labels/m-p/428744#M702600 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I'm trying to store data in a table into a text file, but i'm trying to leave out the labels as I only need the data (which will only ever be one field/row)</P><P></P><P>My Current code is as follows:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13482184833858859" jivemacro_uid="_13482184833858859"><P>NOCONCATENATE</P><P>EmailSubject:</P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp; LTRIM(MaxString(EmailSubjTmp)) as 'SubjectLine'</P><P>RESIDENT [TMPEmailSubject];</P><P></P><P>DROP TABLE TMPEmailSubject;</P><P></P><P><STRONG>STORE SubjectLine FROM EmailSubject INTO [EmailSubject.txt](txt, codepage is 1252, no labels, delimiter is '\n', no quotes);</STRONG></P></PRE><P></P><P>For some reason, in the STORE line, evey parameter after txt is normal text and not highlighted as usual....codepage for example shows up as an error when i do a syntax check.</P><P></P><P>My resulting file has in the first line 'SubjectLine' and on the second line is the data. I ONLY want the data.</P><P></P><P>Any help will be highly apprciated.</P></BODY></HTML> Fri, 21 Sep 2012 09:10:54 GMT https://community.qlik.com/t5/QlikView/How-to-Export-Table-and-exclude-Field-Labels/m-p/428744#M702600 2012-09-21T09:10:54Z Re: How to Export Table and exclude Field Labels https://community.qlik.com/t5/QlikView/How-to-Export-Table-and-exclude-Field-Labels/m-p/428745#M702601 <HTML><HEAD></HEAD><BODY><P>hi.</P><P>You can try to use macro to export whan you want.</P></BODY></HTML> Fri, 21 Sep 2012 09:43:44 GMT https://community.qlik.com/t5/QlikView/How-to-Export-Table-and-exclude-Field-Labels/m-p/428745#M702601 whiteline 2012-09-21T09:43:44Z