Omit rows from table load; not working

[gshockxcc]

I am trying to load data with headers in row 1, short description in row 2, data in rows 3 ... 86,400, etc.  I want to omit row two only.  I'm trying load as follows:

(txt, codepage is 1252, embedded labels, delimiter is ',', Where RowNo() <> 2);

I have also tried:

(txt, codepage is 1252, embedded labels, delimiter is ',')

Where RowNo() <> 2;

No matter which method I try, I get the same result.  See attached.

[Thiago_Justen_]

Kristan,

Maybe this will be helpful:

Your_Table_Temp:

Load

*,

RowNo() as ID;

Load

*

From Your_Text_File

(txt, codepage is 1252, embedded labels, delimiter is ',');

Final_Table:

Load

*

Resident Your_Table_Temp Where ID <> 1;

Cheers

[jonathandienst · Accepted solution]

RowNo()n references output lines. You need RecNo() instead.

(txt, codepage is 1252, embedded labels, delimiter is ',')

Where RecNo() > 1;

[gshockxcc]

Brilliant!  Thanks, Jonathan.  That's exactly what I was looking for.