topic Re: Omit rows from table load; not working in App Development

Omit rows from table load; not working

gshockxcc — Sun, 17 Jun 2018 20:16:26 GMT

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.

Re: Omit rows from table load; not working

Thiago_Justen_ — Mon, 18 Jun 2018 02:56:28 GMT

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

Re: Omit rows from table load; not working

jonathandienst — Mon, 18 Jun 2018 05:41:24 GMT

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

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

Where RecNo() > 1;

Re: Omit rows from table load; not working

gshockxcc — Mon, 18 Jun 2018 09:10:02 GMT

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