topic Skip first few lines in a csv file in QlikView

Skip first few lines in a csv file

Thu, 03 Jun 2010 12:13:09 GMT

Morning all,

Is there a way i can import a csv file but skip the first few lines? I have a bunch of info I don't need in the first row.

Thanks,

Tony

Skip first few lines in a csv file

Thu, 03 Jun 2010 12:27:47 GMT

You can use a where clause.

If it does not have anything to differentiate the data you want returned and th data that you don't want returned, add a field to the csv file, do the where clause on there.

Hopes this helps.

SV:Skip first few lines in a csv file

gandalfgray — Thu, 03 Jun 2010 13:04:08 GMT

Use the "header is" clause of the Load-statement:

LOAD @1,
@2
FROM
S:\QVApps\wherever\whatever\alittlefile.txt
(txt, codepage is 1252, no labels, delimiter is '\t', msq, header is 3 lines);

Or in the File wizard:

Set the figure to whatever number of lines you have of course... I just used 3 as an example here

SV:Skip first few lines in a csv file

Thu, 03 Jun 2010 17:31:27 GMT

Thanks Goran, that's just what I was after.

Tony