Conditional Record & Column Mapping

Top  Previous  Next

 

conditional_mapping_gen

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 conditional_mapping_buttons

 

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)

 

conditional_mapping_empty

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

conditional_mapping_column

 

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

conditional_mapping_filled

 

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