Conditonal Statements Combined

[Nuno_Meneses]

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. 

[binuacs · Accepted solution]

@Nuno_Meneses  Try

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

Else Null()

endIf

[PhilipMannering]

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

You can also use the IN() function,

[Felipe_Ribeir0]

Hi @Nuno_Meneses 

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.

[Nuno_Meneses]

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