ETL and Data Integration tools - Modern ETL software for everyone

* Version Number = Advanced ETL Processor Ent. 4.2.3.5

* Repository type = MS Access 2007

* Database type you are working with. = .MDB

* OS = Windows 7

While converting data from an Access DB to a CSV file I have certain fields which are "Required" (such as first name, last name)for the file I am creating. This file will later be used to import into an Oracle DB. I would like to validate the required field in the data and if no data is in the required field send it to a different output writer to create a missing data file of customer records.

This actually very simple thing to do

Put validator after data reader

Than use Is Null function for validations (or Is Empty String)

Use this tutorial as an example

www.dbsoftlab.com/online-tutorials/advan...d-etl-processor.html

Peter