topic Re: Conditional Statement with multiple conditions in Alteryx Designer Desktop Discussions

Conditional Statement with multiple conditions

alijalil — Fri, 18 Nov 2022 08:18:17 GMT

Hello Im trying to build a multi-conditional statement as follows

If([Category]="medicine" and [CountNonNull_Birth_Country]= "5", then "Yes", else "No" endif . For some reason, I get malformed IF statement error at "5". Attached table snapshot below. Thanks in advance!

Re: Conditional Statement with multiple conditions

ShankerV — Fri, 18 Nov 2022 08:24:46 GMT

@alijalil

It is because the column CountNonNull_Birth_COuntry will be INT

Hence when you do the check under "5" double quotes, it is for string.

Many thanks

Shanker V

Re: Conditional Statement with multiple conditions

ShankerV — Fri, 18 Nov 2022 08:25:25 GMT

@alijalil

INT - I try to refer as Interger/Numeric

Re: Conditional Statement with multiple conditions

messi007 — Fri, 18 Nov 2022 08:26:16 GMT

@alijalil,

Please try the formula below :

If ([Category]="medicine" and [CountNonNull_Birth_Country]= 5) then "Yes" else "No" endif

I think you forgot to close parenthesis and CountNonNull type is double that's way I deleted the quotation marks.

Hope this helps!

Regards

Re: Conditional Statement with multiple conditions

binu_acs — Fri, 18 Nov 2022 08:27:28 GMT

@alijalil You need to update your IF Else Formula

Re: Conditional Statement with multiple conditions

ShankerV — Fri, 18 Nov 2022 08:29:39 GMT

@alijalil

Please find the sample output for your issue

Many thanks

Shanker V

Re: Conditional Statement with multiple conditions

Raj — Fri, 18 Nov 2022 08:36:02 GMT

If([Category]="medicine" and [CountNonNull_Birth_Country]= 5 then "Yes", else "No" endif

try this (insert a select tool to convert nonull to int16 if not)

Re: Conditional Statement with multiple conditions

alijalil — Fri, 18 Nov 2022 11:49:33 GMT

@messi007 Thanks, this worked!

Re: Conditional Statement with multiple conditions

alijalil — Fri, 18 Nov 2022 11:50:38 GMT

Thank you all for the responses.

One more thing - do we know where we can get the sample solutions for the practical questions from the Core certification assessment?