3 Replies Latest reply: Jun 18, 2018 5:10 AM by Kristan Sears RSS

    Omit rows from table load; not working

    Kristan Sears

      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.