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

store without header¿?

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

2 Replies
erichshiino
Partner - Master
Partner - Master

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

Not applicable
Author

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.