Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Urgent requirement?

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

10

102

103

104

105

9 Replies
senpradip007
Specialist III
Specialist III

Could you please upload your script?

MK_QSL
MVP
MVP

How you will made your datamodel without header or fieldname?

Not applicable
Author

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?

MarcoWedel

Hi,

this sounds like an answer of the OP?

Are you using multiple accounts?

regards

Marco

danielrozental
Master II
Master II

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

ashfaq_haseeb
Champion III
Champion III

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

Anonymous
Not applicable
Author

Try :

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

maxgro
MVP
MVP

DIRECTORY;

a:

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);

Not applicable
Author

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;