I need your help on how to skip reading the first 10 rows of a sequential file.
I have a csv file, the first 10 records are metadata, the rest of the file is data records.
Metadata have different field format from non-metadata.
I try to read in the data, but not the metadata using sequential file stage. But I don't see an option that let me SKIP the first XX records so I can read from row 11 onward.
Define the columns in the stage to match the data columns in the file, the records from 11 on. The stage will automatically discard the first 10 for not matching that.
-craig
"You can never have too many knives" -- Logan Nine Fingers
that's what I am doing now, define the columns for records from row 11 onward. This resulted in a set of warnings in the log.
I guess I can downgrade the warnings. But I was hoping there're other options.