The Out-of-the-box (OOTB) CSV Database Collector uses the HXTT driver supplied with the RSA Identity Governance & Lifecycle software. The HXTT driver does not support keywords that allow you to ignore the first few rows of the source data file other than the file header row. This RSA Knowledge Base Article explains how to configure an OOTB CSV Database Collector to ignore the first X number of rows when collecting data.
To ignore the first few rows of the CSV data file during collection, use a data query similar to the following where X is the number of rows to ignore at the beginning of the data file.
SELECT COLUMN1, COLUMN2, COLUMN3 FROM DATAFILENAME WHERE _ROWID_ > X
COLUMN# are the column names.
DATAFILENAME is the name of the CSV data source file.
X is the number of rows at the beginning of the file to ignore not including the header row.
This solution applies only to the HXTT driver that is supplied with the RSA Identity Governance & Lifecycle product and may not work with other drivers.
To find out what property names are supported by the HXTT driver, see Chapter 2. Installation on the HXTT web site.