Navigation:  Data Management > Tab Mappings > Options > Manual Condition Builder

When the condition (IF or ELSIF) you need to build require more than TWO 'elements' then you can use the manual Condition Builder :

 

 

You have available the

LIST of all COLUMNS

LIST of ALL OPERATORS

LIST of ALL FUNCTIONS

 

You can copy paste your condition from any outside text editor

 

You can hand write your condition

 

You can use the inbuilt condition builder to help you write it :

1. Place the cursor where you want to add a condition

2. Select a COLUMN (single click)

3. Double-Click on any FUNCTION

 

the "Expression" part will be replaced by the selected COLUMN

ie : select CITY and double-click on Instring(Text, Expression,1,1) and the Condition Builder will add after cursor position this Instring ( Text, CITY , 1,1)

 

Double clicking on any OPERATOR simply adds it after cursor position.

 

This is the type of condition you could build :

 

 

city <> 'JACKSONVILLE' and city <> 'MEMPHIS' and city <> 'LA PORTE' and city <> 'ORLANDO' and statecode <> 'FL' and statecode <> 'IL'

 

These manual conditions can be used as any types of conditions (IF / ELSIF - non linked to another condition - single condition - linked to Functions or as FILTERS)

 

NOTE : all STRING values MUST be QUOTED

 

IMPORTANT NOTE : The Condition Builder has an inbuilt evaluation feature

ie : after entering any condition text value etc, simply use the TAB key of your keyboard and the ICON will display the result either in GREEN or in RED !

if for example you have a spelling mistake in a column or a function then it will be displayed in RED (the condition returns FALSE)

 

---