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.
Solved! Go to Solution.
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
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