All versions of Visual Importer ETL can filter data during import.

If the data source is a database filtering data is simple just write SQL statement and filter the data there.

If the data source is a text file  it is also possible to filter data using the following example:

Consider the following situation:

The source file has two kinds of records

RECORDTYPE=1 - Customer information
RECORDTYPE=2 - Invoices

 If you want to use multiple criteria use the following example


 ||      - OR
 && - AND
 !      - NOT