Variable IF statement in a TI Process

[JJ2]

Hi Everyone, I have a very simple question. I'm using a TI process to create a hierarchical dimension from an ODBC excel source. I want to create a new variable (to be used as a consolidation/roll-up) with an IF statement based on the values in the Country dimension being Germany or France. So if the value is Germany or France then the variable (region) value should say Germany or France. Any other value in the country element should state 'Other'. The syntax I'm using in the Region variable is as follows:
IF (Country @= 'Germany');
(Region @='Germany');
ELSEIF (Country @= 'France');
(Region @='France');
ELSE (Region @= 'Other');
ENDIF;

Sorry for the simplicity of the question and the syntax shown above, very new to TM1. All responses are appreciated. Thanks

[tomok]

IF (Condition1);
Statement1;
ELSIF (Conditon2);
Statement2;
ELSE;
Statement3;
ENDIF;

[Martin Ryan]

IF (Country @= 'Germany');
(Region @='Germany');
ELSEIF (Country @= 'France');
(Region @='France');
ELSE (Region @= 'Other');
ENDIF;

'@=' is for comparing two variables, not for assigning values to variables. So the above should be

IF (Country @= 'Germany');
Region ='Germany';
ELSEIF (Country @= 'France');
Region ='France';
ELSE;
Region = 'Other';
ENDIF;

You could also do
if(country@='Germany' % country@='France');
region=country;
else;
region='Other';
endif;

Martin

[Alan Kirk]

Hi Everyone, I have a very simple question. I'm using a TI process to create a hierarchical dimension from an ODBC excel source. I want to create a new variable (to be used as a consolidation/roll-up) with an IF statement based on the values in the Country dimension being Germany or France. So if the value is Germany or France then the variable (region) value should say Germany or France. Any other value in the country element should state 'Other'. The syntax I'm using in the Region variable is as follows:
IF (Country @= 'Germany');
(Region @='Germany');
ELSEIF (Country @= 'France');
(Region @='France');
ELSE (Region @= 'Other');
ENDIF;

Sorry for the simplicity of the question and the syntax shown above, very new to TM1. All responses are appreciated. Thanks

You're mixing up your comparison and assigment operators. You use @= if you want to compare one string variable to another, and see whether the two match. (You just use = to compare numeric values.) If you want to assign a value to another variable (whether string or numeric) you just use the = operator. So the code that you have above should actually be:

Code: Select all

IF (Country @= 'Germany');
   Region ='Germany';
ELSEIF  (Country @= 'France');
    Region ='France';
ELSE 
    Region = 'Other';
ENDIF;

[JJ2]

Thanks Martin! Your examples worked perfectly!

[jstrygner]

You could also do
if(country@='Germany' % country@='France');
region=country;
else;
region='Other';
endif;
Martin

Or:

Code: Select all

region=if(country@='Germany' % country@='France', country, 'Other');

Not tested in a TI, but the idea should work.