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