Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need to store a .csv file without the header,
I stored it and then I loaded it removing the first line, the problem is that I lose the format of my original fields and I need to keep them...
Any idea?
Thanks,
David
Hi,
Maybe you could convert the fields to a text format before storing it:
Like this:
noconcatenate
Table:
Load
...
text( Date( SalesDate,'DD/MM/YYYY') as SalesDate,
....
Resident OriginalTable;
store Table into...
etc...
Hope this helps...
Erich
Hi,
While setting up the script to load CSV file, in the "Table Files Wizard" specify header size Rows to 1, then in the Options set Labels None.
So you need not delete the header in the file manually.
If not clear please attach a sample app.