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

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

Where
 ||      - OR
 && - AND
 !      - NOT

 

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies