i need assitance to create conditions for the statement

[AvinashBhawsar]

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]

Hi @AvinashBhawsar 

That function would be written as:

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

Set up the formula to overwrite the Notes column

Pedro.

[pedrodrfaria · Accepted solution]

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 solution]

@AvinashBhawsar,

Please see below how you can do it :

Attached the workflow,

Regards,