{"id":4599,"date":"2025-01-03T16:56:30","date_gmt":"2025-01-03T16:56:30","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/?p=4599"},"modified":"2026-01-20T15:35:42","modified_gmt":"2026-01-20T15:35:42","slug":"using-if-and-while-statements-in-ibm-planning-analytics-turbointegrator-processes","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/using-if-and-while-statements-in-ibm-planning-analytics-turbointegrator-processes\/","title":{"rendered":"How Do I Use IF and WHILE Statements in IBM Planning Analytics TurboIntegrator Processes?"},"content":{"rendered":"

Using IF and WHILE Statements in IBM Planning Analytics TurboIntegrator Processes<\/strong><\/p>\n

IBM Planning Analytics provides powerful scripting capabilities within TurboIntegrator (TI) processes, allowing developers to create dynamic, flexible models. Two foundational constructs used in these scripts are the IF<\/strong> and WHILE<\/strong> statements. IF<\/strong> statements are primarily used for conditional execution of code, and WHILE <\/strong>statements are used to execute a portion of code iteratively. This article explores how to effectively use these statements to control logic and iterate through operations.<\/p>\n

\"\"<\/p>\n

IF Statements<\/strong><\/p>\n

An IF<\/strong> statement is used to evaluate a condition and execute a block of code only if that condition is true. Optionally, as many ELSEIF <\/strong>statements can be included within the IF <\/strong>statement to check multiple conditions and execute different code respectively. As another optional addition to the statement, an ELSE <\/strong>can be used to execute code when no other conditions in the IF <\/strong>statement have been met.<\/p>\n

Syntax<\/strong><\/p>\n

IF( Condition ) ;<\/p>\n

# Code to execute if Condition is true;<\/p>\n

ELSEIF( AnotherCondition ) ;<\/p>\n

# Code to execute if AnotherCondition is true and no preceding conditions are true;<\/p>\n

ELSE ;<\/p>\n

# Code to execute if no preceding conditions are true;<\/p>\n

ENDIF ;<\/p>\n

As seen in the syntax above, the IF <\/strong>statement starts with \u201cIF<\/strong>\u201d directly followed by the condition that is being checked by the statement within parentheses. The code in the lines below the statement will execute as long as the condition is true. Any applicable code can be executed here, including additional nested IF <\/strong>statements. The code to be executed is traditionally indented slightly to make the code easier to read.<\/p>\n

At this point, if there is only one condition to check, the IF<\/strong> statement can be finished by adding the ENDIF<\/strong> to a new line under the current code. The IF <\/strong>statement, as a whole, includes everything between the \u201cIF<\/strong>\u201d and the \u201cENDIF<\/strong>\u201d. If there are additional conditions to be checked with associated code to be run, ELSEIF <\/strong>statements can be included. IF there is code that should be run when all checked conditions are false, an ELSE <\/strong>statement can be added.<\/p>\n

It should be noted that no mater how many conditions are checked during the statement, only the first condition that is TRUE will execute its associated code. Because of this, the order of conditions to check is important when adding ELSEIF<\/strong> to the statement. If the first condition is evaluated to be TRUE, no other code associated with other conditions will be executed even if their conditions would have evaluated to be TRUE.<\/p>\n

Practical Example<\/strong><\/p>\n

IF( x > 5 ) ;<\/p>\n

answer = ‘x is greater than 5’ ;<\/p>\n

ELSEIF( x < 5 ) ;<\/p>\n

answer = ‘x is less than 5’ ;<\/p>\n

ELSE ;<\/p>\n

answer = ‘x is 5’ ;<\/p>\n

ENDIF ;<\/p>\n

Simply defines a text variable based on the value of x.<\/em><\/p>\n

\u00a0<\/em><\/p>\n

Tips for Effective Use<\/strong><\/p>\n