Skip only the second row from the flat file

dataservices job design
1

Hi,

I need to skip only the second row from the flat file.
Please advise.

its_ranjan (BOB member since 2011-02-16)

2

Is there an identifier for the row? If not, you could generate a running serial number using gen_row_num() function (after ordering your records as required). You could put it into a staging table. Then you could exclude the row where rownum = 2

nithya_raj (BOB member since 2007-02-03)

3

I used ‘ignore row marker’ in the file format editor using the row field name to achieve the result.

its_ranjan (BOB member since 2011-02-16)