This example shows how to use logical operations to compare two values

Source Data Example

Advanced ETL Processor allows using multiple ways of transforming the data, which one to choose depends on the customer requirement. Using calculation transformation  usually is the slowest option 

Steps to follow:

  • Download and install Advanced ETL Processor [Link]
  • Download and Unzip example [Link]
  • Create a new transformation and open .ats file
  • Double-click on the Reader object and amend the source file path
  • Double-click on the Writer objects and amend the target file path leaving the calculation intact
  • Press the green arrow to run the transformation

Screenshots

Data flow

Example 1: using compare values transformation function

Using compare values transformation function

Example 2: using calculations

Using calculations

Calculation properties

Example 3: using lookup

Using lookup

Lookup transformation properties

Lookup transformation properties

Example 4: using If Equal to the transformation function

If Equal to the transformation function

There are other ways of transforming the data please contact us if you need help.

Visit ETL Tools Forum