How to split a file with Advanced ETL Processor

One of the benefits of using Advanced ETL Processor is the ability to load data into multiple targets. Below is list of customer's orders exported from a CRM system. There are two different kinds of records

RECORD_TYPE=1 - Customer Details
RECORD_TYPE=2 - Customer Orders

Advanced ETL Processor - Reader Object Showing Customer's Orders

You can actually load list of customers and list of orders into two completely different databases. In this example we use Validator object and validation function "Is Equal To" to separate dataflow

Advanced ETL Processor - Splitting Files

The Result of ETL Transformation - List of Customers

Advanced ETL Processor - List of Customers

The Result of ETL Transformation - List of Orders

Advanced ETL Processor - Splitting Files - Customer Orders

Feel free to try Advanced ETL Processor today. All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.

Watch Online Flash Demo
Download Advaced ETL Processor now