I have to use "in" condition within "if"

deesh · Post by **deesh** » Wed Apr 08, 2009 5:53 am

Hi,
Can any one help in this case,

if OKCUA4='' and OKCUA3 in (counties) then OKCUA2
else if OKCUA4='' and OKCUA3 not in (counties) then OKCUA3
else if OKCUA4 in (counties) then OKCUA3
else OKCUA4

shalini11 · Post by **shalini11** » Wed Apr 08, 2009 5:58 am

if OKCUA4='' and (OKCUA3=counties1 or OKCUA3=counties2...) then OKCUA2
else if OKCUA4='' and (OKCUA3<>counties1 or OKCUA3<>counties1 ...)then OKCUA3
else if (OKCUA4=counties1 or OKCUA4=counties2...)then OKCUA3
else OKCUA4

Mike · Post by **Mike** » Wed Apr 08, 2009 6:50 am

If you have a manageable number of counties, then you can use the approach suggested by shalini11. If you have hundreds or thousands of counties to check, then you'd want to use the lookup stage to implement your "in" and "not in" logic.

Mike

DSguru2B · Post by **DSguru2B** » Wed Apr 08, 2009 10:04 am

Or maybe the index function.

kandyshandy · Post by **kandyshandy** » Thu Apr 09, 2009 8:36 am

shalini11 wrote:if OKCUA4='' and (OKCUA3=counties1 or OKCUA3=counties2...) then OKCUA2
else if OKCUA4='' and (OKCUA3<>counties1 or OKCUA3<>counties1 ...)then OKCUA3
else if (OKCUA4=counties1 or OKCUA4=counties2...)then OKCUA3
else OKCUA4

It should be AND, not OR

if OKCUA4='' and (OKCUA3=counties1 or OKCUA3=counties2...) then OKCUA2
else if OKCUA4='' and (OKCUA3<>counties1 AND OKCUA3<>counties1 ...)then OKCUA3
else if (OKCUA4=counties1 or OKCUA4=counties2...)then OKCUA3
else OKCUA4

Or DSGuru's Index idea.