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 a 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

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

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

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL Forum

  • knowledgebase/how_to_split_a_file_with_advanced_etl_processor.txt
  • Last modified: 14/07/2021 08:47
  • by admin