Conditional Record & Column Mapping

If you need to have MULTIPLE CONDITIONAL mapping for a given column or record level then use this option

Start by checking this box.

Then use these buttons to ADD - EDIT & DELETE records

Inserting a new record will open this window for you to define your conditions

Be careful : here is where you define if the condition must be applied at RECORD level or at COLUMN level (use the appropriate checkbox)

Select in the drop down box the column of the SOURCE Table to "work" on (the ID will automatically be filled in for you)

Then define the condition type using Condition Type drop down box (always displayed in english and translations are provided on the right side of this screen)

Available conditions are :

=

<>

>

<

INSTRING

NOT INSTRING

LEFT(

RIGHT

EMPTY

NOT EMPTY

in the case of Starts with and Ends with the lenght of the Condition value is used to check for existence

Finally fill in the "Condition value" to tell the utility all it needs

Click on the Green "OK" button to save your record and this is what you will see

This will "tell" the utility that when it comes to this selected column - here CUS:ADDRESS - it will have to EITHER

Transfer the value of this column only if the value in the column CUS:ADDRESS contains "6"

OR

AT RECORD LEVEL (see the small icon on the left) the value in the column ADMINOK if the value is equal to '251' then only will this complete record be transferred otherwise it will not

etc ... as you can add as many conditions as you want