Adapter for Delimited Files: Skip Rows Before Header

When you upload or create a synonym for a delimited file, you can indicate that a header row exists that provides column names. Sometimes, delimited files have other rows above the header row. These rows may be blank or may contain general heading information that do not provide attributes that should be included in the synonym. The synonym creation parameters screen for delimited files now provides an option for indicating the number of rows that need to be skipped before the header row, as shown in the following image.

Enter the number of rows to skip in the field labeled Number of first rows to skip.

For example, in the following image, the header row is row 5.

Entering 4 in the Number of first rows to skip field adds the following attribute in the Access File.

SKIP_ROWS=4

This number is used both when creating the synonym and reading the data. The Show File option that is available when creating a synonym now shows all lines, including blank lines, to aid you in determining how many lines should be skipped.