Conditonal Statements Combined

Hello again,

I need some help with conditional statements. This format is nor supported by alteryx but I need something like this

IF [A] = 'EU' and ( [B] != 'PT' or [B] != 'DE' .............or [B] != 'DK')

Then 'Issue'

Else Null()

Endif

I've tried a lot of statement but I can't figure out how to do it. Thanks.

Help

Accepted answers

IF [A] = 'EU' and [B] Not IN (‘DE’,’DK’,….) Then ‘Issue’

Else Null()

endIf

IF [A] = 'EU' and [B] Not IN (‘DE’,’DK’,….) Then ‘Issue’

Else Null()

endIf

Why isn't it supported? That should work...

You can also use the IN() function,

Seems to me that you can use this way to simplify the formula, and the result will be as expected:

IF [A] = 'EU' and [B] not in ('PT' , 'DE', ............. ,'DK')

Then 'Issue'

Else Null()

Endif

philipmannering

I thnk you want to use AND all the way.

Because,

[Field] != 'X' or [Field] != 'Y'

Will always evaluate to True.

IF [A] = 'EU' and [B] not in ('PT' , 'DE', ............. ,'DK') works perfectly thank you all