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 · Accepted solution]

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

[Kenda · Accepted solution]

Hey @eliasg! Try taking the quotes off around your Int field.

[eliasg]

thanks! will try that now.

---

@NicoleJohnson wrote:

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

---

[eliasg]

@nicolejohnson & @barnesk

thank you both, it's working now!