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

Data filter

Expression Builder

Multiple criteria filter

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


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

Confused? Ask question on our ETL Forum
Last updated: September 17, 2022