topic Re: Urgent requirement? in QlikView

Urgent requirement?

Fri, 07 Nov 2014 11:42:48 GMT

I have a table in My script.

I want to load the table data into.txt file without header how can i?

suppose i have a table Table1

Eno

100

101

102

103

104

105

i want to store the data in txt file without header

100

102

103

104

105

Re: Urgent requirement?

senpradip007 — Fri, 07 Nov 2014 11:45:16 GMT

Could you please upload your script?

Re: Urgent requirement?

MK_QSL — Fri, 07 Nov 2014 11:55:17 GMT

How you will made your datamodel without header or fieldname?

Re: Urgent requirement?

Fri, 07 Nov 2014 12:16:17 GMT

Hi,

thanks for ur reply

i am using

store [Tablename] into C:\desktop\sample.txt;

But here i want in sample.txt i need only data without headers.

I tried

store [Tablename] into C:\desktop\sample.txt

(txt, delimeter '\t', header 1 lines);

it's not working?

Re: Urgent requirement?

MarcoWedel — Fri, 07 Nov 2014 16:47:25 GMT

Hi,

this sounds like an answer of the OP?

Are you using multiple accounts?

regards

Marco

Re: Urgent requirement?

danielrozental — Fri, 07 Nov 2014 17:46:51 GMT

It's not possible, here's something you can try Create txt files without the header using the script.

Re: Urgent requirement?

ashfaq_haseeb — Fri, 07 Nov 2014 18:12:24 GMT

Hi,

There no direct way.

But for sure this macro will help you.

VB Macro to Export Table to CSV with No headers !

Regards

ASHFAQ

Re: Urgent requirement?

Anonymous — Fri, 07 Nov 2014 18:56:12 GMT

Try :

store [Tablename] into C:\desktop\sample.txt (txt,, no labels) ;

Re: Urgent requirement?

maxgro — Fri, 07 Nov 2014 19:03:22 GMT

DIRECTORY;

load rowno() as id, * inline [

Eno

100

101

102

103

104

105

];

let v = peek('Eno',0);

t: NoConcatenate load Eno as $(v) Resident a where id > 1;

store t into a.txt (txt);

Re: Urgent requirement?

Sat, 08 Nov 2014 11:45:19 GMT

Emp:

LOAD

Inline

[

Eno

100

101

102

103

104

105

]

;

Let vFirstVal = Peek('Eno',0);

Final:

LOAD

Eno as $(vFirstVal)

Resident Emp

Where Eno <> $(vFirstVal);

STORE Final into Header_Exclude.txt (txt);

drop Tables Emp,Final;