000032568 - How to ignore X number of rows while collecting data from CSV files in RSA Identity Governance and Lifecycle

Document created by RSA Customer Support Employee on Oct 9, 2017
Version 1Show Document
  • Comment • 0
  • View in full screen mode

Article Content

Article Number000032568
Applies ToRSA Product Set: RSA Identity Governance and Lifecycle
RSA Version/Condition: All
 
IssueThis article explains how to collect the data using out of the box CSV collector with steps to ignore the first X number of rows while collecting data from the data file. 
Resolution

The out of the box CSV collector uses HXTT driver. It doesn't support any keyword that allows you to ignore first few rows beside the header. However, customer can simply use the data query in following format to ignore X number of rows.
 



SELECT COLUMN1, COLUMN2, COLUMN3 FROM DATAFILENAME WHERE _ROWID_ > X

Where,


COLUMNX is column name;
DATAFILENAME is name of the file where you are collecting data from; and
X is number of line you want to ignore not including the header;



You can use the custom driver of your choice to collect data in collector definition under Database Connection with DB Type : Custom which allows keywords to ignore number of rows. The solution above only applies to HXTT driver that is supplied with the product and may not work with other drivers that are available out there. 

Attachments

    Outcomes