Turbo Integrator: Any way to use or in an IF statement?

[ChrisF79]

Very new question here but I have a lot of IF statements that could be minimized if I could use OR within the first part of the clause. What I'm trying to write is something like, "If entity is 1000 or 5000, do this..." Currently I'm doing:

Code: Select all

IF(entity @= '1000');
  ... do something;
ENDIF;
IF(entity @= '5000');
   ... do something (same as above);
ENDIF;

I'm using Turbo Integrator 9.4.1. Thanks!

[jrizk]

Hi.

IF ( entity @= '1000' % entity @= '5000' );
... do something;
ENDIF;

check out Tm1 help on 'logical operators'

[jrizk]

& = AND eg (Value1 > 5) & (Value1 < 10) Returns TRUE if the value is greater than 5 and less than 10.
% = OR eg (Value1 > 10) % (Value1 < 5) Returns TRUE if the value is greater than 10 or less than 5.
~ = NOT eg ~(Value1 > 5) Equivalent to (Value1 <= 5)

[ChrisF79]

Perfect, thank you! I remembered us going over it in a class I took but I couldn't find it anywhere. Thanks a lot!

[SueZhaZa]

& = AND eg (Value1 > 5) & (Value1 < 10) Returns TRUE if the value is greater than 5 and less than 10.
% = OR eg (Value1 > 10) % (Value1 < 5) Returns TRUE if the value is greater than 10 or less than 5.
~ = NOT eg ~(Value1 > 5) Equivalent to (Value1 <= 5)

Gee Thanks.. i know i'm bit outdated with the post but its helpful..
Actually i need to know more on picking up subset using csv files whereby some of the cell is either null or empty..
Thanks again!

[Christopher Kernahan]

Hi SueZhaZa,

Welcome to the forum.

Actually i need to know more on picking up subset using csv files whereby some of the cell is either null or empty..

Your question doesn't make sense to me; I suggest you create a new topic and provide more info as described in the How To Post Thread http://www.tm1forum.com/viewtopic.php?f=3&t=1037

[SueZhaZa]

yup.. i already did and manage to solve it... Love the helps this forum provides.. Superb!

http://www.tm1forum.com/viewtopic.php?f=3&t=7094