Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Export Table and exclude Field Labels

Hi All,

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)

My Current code is as follows:

NOCONCATENATE

EmailSubject:

LOAD

    LTRIM(MaxString(EmailSubjTmp)) as 'SubjectLine'

RESIDENT [TMPEmailSubject];

DROP TABLE TMPEmailSubject;

STORE SubjectLine FROM EmailSubject INTO [EmailSubject.txt](txt, codepage is 1252, no labels, delimiter is '\n', no quotes);

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.

My resulting file has in the first line 'SubjectLine' and on the second line is the data. I ONLY want the data.

Any help will be highly apprciated.

1 Reply
whiteline
Master II
Master II

hi.

You can try to use macro to export whan you want.