000032568 - How to ignore the first X number of rows when collecting data from CSV files in RSA Identity Governance & Lifecycle

Document created by RSA Customer Support Employee on Oct 9, 2017Last modified by RSA Customer Support Employee on Aug 28, 2020
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000032568
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle 
RSA Version/Condition: All
 
IssueThe 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.
 
ResolutionTo 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.
 
NotesTo find out what property names are supported by the HXTT driver, see Chapter 2. Installation on the HXTT web site.
 

Attachments

    Outcomes