If statement logic issue

eliasg

Hello,

I'm having a hard time trying to figure out why the following logic is not working. It's always picking up the last condition and tagging everything as not mapped. The two lines are just a sample, the whole thing is about 500 lines...

field 1 the out field are both vstring and acct is int

IF [field1] ='text1' AND [ACCT] ='12345' THEN 'ABC' ELSEIF
[field1] ='text2' AND [ACCT] ='67890' THEN 'DEF'
else'Not mapped' endif

Any input is appreciated.

-Elias

NicoleJohnson

If your [ACCT] field is Int, then you may just need to remove the single quotes around the '12345' and '67890' parameters, so it would look something like this:

IF [field1] ='text1' AND [ACCT] =12345 THEN 'ABC' ELSEIF
[field1] ='text2' AND [ACCT] =67890 THEN 'DEF'
else 'Not mapped' endif

Let me know if that works!

NJ