Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Could you please upload your script?
How you will made your datamodel without header or fieldname?
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?
Hi,
this sounds like an answer of the OP?
Are you using multiple accounts?
regards
Marco
It's not possible, here's something you can try Create txt files without the header using the script.
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
Try :
store [Tablename] into C:\desktop\sample.txt (txt,, no labels) ;
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);
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;