topic Re: When importing multiple csv in a folder, the header appears in the values in QlikView

When importing multiple csv in a folder, the header appears in the values

Fri, 09 Nov 2012 15:08:17 GMT

Dear all,

I have a number of csv files in a folder, named File1, File2 etcetc.

I am loading from them using explicit labels, as I need to rename some fields

problem is, if I use the following script

FROM
[Folder\File*.csv]
(txt, codepage is 1252, explicit labels, delimiter is ',', msq);

In the resulting fields the header is one value of the field.

E.g, if it was

LOAD

@1 as Item

In the resulting *.qvw, the Item fields is also going to contain an 'Item' value..

any idea how to overcome this??

Im clearly stating I have this problem when using explicit labels, because if I use embedded labels, the problem does not show up..

Thank you!

Re: When importing multiple csv in a folder, the header appears in the values

Gysbert_Wassenaar — Fri, 09 Nov 2012 15:14:40 GMT

I think you want to use 'embedded labels' instead of 'explicit labels'

from the help file:

The field names can be found in different places of the file. If the first record contains the field names, embedded labels should be used. If there are no field names to be found, no labels should be used. In dif files, a separate header section with explicit field names is sometimes used. In such a case, explicit labels should be used. If nothing is specified, embedded labels is assumed, also for dif files.

Re: When importing multiple csv in a folder, the header appears in the values

Fri, 09 Nov 2012 15:16:47 GMT

I actually updated my post meanwhile you replied.

With embedded labels there is not such a problem, but since this csv files are updated weekly, with rolling data, the headers are changing too, according to the day to which they refer to.

Therefore I need to take field position when I do the load...

Re: When importing multiple csv in a folder, the header appears in the values

shree909 — Fri, 09 Nov 2012 15:16:47 GMT

Hi when ur importing the .csv files from edit script using table files , once u select the files u have labels on extreme right , if u use embedded labels then u will get rid of @1..

hope this helps

Re: When importing multiple csv in a folder, the header appears in the values

Fri, 09 Nov 2012 15:17:58 GMT

Please look above post of mine

I need to use @1, @2 etcetc, beacuse headers labels are changing weekly!

Re: When importing multiple csv in a folder, the header appears in the values

Gysbert_Wassenaar — Fri, 09 Nov 2012 15:26:29 GMT

I don't quite understand what you need. If you want to skip the header you can use 'no labels' in combination with 'header is 1'. That way you will only load the data.

Re: When importing multiple csv in a folder, the header appears in the values

Fri, 09 Nov 2012 15:29:21 GMT

Actually, yes!

you are right!

the solution was so obvious (and my brain is fried up, seems like), that I did not think about it!

Since I am creating my own labels and using the field positions, I can skip all the first rows of all files!

nice, it is always like this, the most ingenious solutions, are the simplest!