i need assitance to create conditions for the statement

Question

Hi, i am trying to apply if function for the below statements, however, unable to do it since i am new to Alteryx.

Statement 1 :- If Column (CWLCollateralStatusTypeShort) is Accepted or None then column (Notes) should be "Loan Not Reported on TR".

: Loan Not Reported on TR this comment should come up automatically in "Notes" Column after applying the expression as Notes column is already blank.

Thanks for your the help and taking out time to respond from your busy schedule.

pedrodrfaria · Accepted Answer

Hi @AvinashBhawsar

Realized I had a typo, I attached the WF as well:

if [CWLCollateralStatusTypeShort] = 'Accepted' or [CWLCollateralStatusTypeShort] = 'None' then 'Loan Not Reported on TR' else null() endif

Pedro.

messi007 · Accepted Answer

@AvinashBhawsar,

Please see below how you can do it :

Attached the workflow,

Regards,