i've got a fixed length file in entrance which contains a first line and an eof like this :
the first two caracters is a field named id_occ
i define a file reader schema for occurs begin 02. i don't want the first and last row. i can delete it on unix with a sed command but in the tpt can i ignore it ?
for ignore first line i can use skiprow option but for the last line ?
is it possible with the AcceptMissing option and a where condition on id_occ='02' in insert order ?
thanks for response
When you are selecting from your dataconnector operator, add a WHERE clause:
WHERE id_occ = '02'
That will bypass any records from the file that do not have '02' in that field.