topic Re: store without header¿? in QlikView

store without header¿?

Fri, 08 Jul 2011 08:20:34 GMT

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

erichshiino — Tue, 12 Jul 2011 01:10:35 GMT

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

Tue, 12 Jul 2011 06:20:16 GMT

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.