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

14/06/2015 07:36 · admin
  • vimpe/howto/filter_data.txt
  • Last modified: 14/07/2015 06:16
  • by admin