Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
RowNo()n references output lines. You need RecNo() instead.
(txt, codepage is 1252, embedded labels, delimiter is ',')
Where RecNo() > 1;
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
RowNo()n references output lines. You need RecNo() instead.
(txt, codepage is 1252, embedded labels, delimiter is ',')
Where RecNo() > 1;
Brilliant! Thanks, Jonathan. That's exactly what I was looking for.