Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Honored Contributor II

Re: How to Export Table and exclude Field Labels

hi.

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