How to ignore the first X number of rows when collecting data from CSV files in RSA Identity Governance & Lifecycle
4 years ago
Originally Published: 2016-02-16
Article Number
000065099
Applies To
RSA Product Set: RSA Identity Governance & Lifecycle 
RSA Version/Condition: All
 
Issue
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.
 
Resolution
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.
 
Notes
To find out what property names are supported by the HXTT driver, see Chapter 2. Installation on the HXTT web site.
 

Related Articles

Trending Articles

Don't see what you're looking for?