Filtering data

When data source is a database best way to filter data is to use where statement for files is filter expression

Click filter button to build filter expression

Basic Filter

Load data for specific customer

[RECORDTYPE]=1

Multiple criteria filter

([RECORDTYPE]=1) or ([RECORDTYPE]=56)

Add brackets for complex expressions

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

  • aetle/import/filter_data.txt
  • Last modified: 15/05/2018 08:20
  • by admin