Lost Password?
No account yet? Register
Increase font size Default font size Decrease font size Narrow screen resolution Wide screen resolution Auto adjust screen size default color red color blue color yellow color orange color

Filtering source data

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 following example:

consider the following situation:

The source file have two kind of records

RECORDTYPE=1 - Customer information
RECORDTYPE=2 - Invoices


 

If you want to use multiple criteria use following example

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

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

 

Testimonials

I had my first upload running within 10 minutes of installing Visual Importer ETL   

Gene Kovacs,
Director of Technical Business Operations,
A2B

 

Free Newsletter

Please provide your Name and Email address so that we can tell you about latest releases, new features and free offers.






b.150.100.16777215.0..Screenshots.AdvancedETLPro.Advanced_ETL_Processor_Pro_Report.jpg
DB Software Laboratory - Intel Software PartnerDB Software Laboratory - My SQL Ready Partner
DB Software Laboratory Embacadero Technology Partner