Multiple If conditions with left condition

[F600314]

Hi All,

I am trying to get "Loans" as output by applying following formula :

IF [Category Code (Segment Only)] = 2000 and [Category Code (Category Only)] = 40 and [Category Code (Sector Only)] = "50" and Left([Security Number (Full)],2="LX" then "Loans"

I am unable to get the desired output by applying above.

Appreciate your help

Thanks

Vishal

[fmvizcaino · Accepted solution]

Hi @F600314 ,

You are missing the last part of the IF function.

IF [Category Code (Segment Only)] = 2000 and [Category Code (Category Only)] = 40 and [Category Code (Sector Only)] = "50" and Left([Security Number (Full)],2="LX" then "Loans"

Else 'anything else'

Endif

[BenMoss]

Hi!

As a leader in the Alteryx Community, I have the ability to identify & mark accepted solutions on behalf of community members - and recently did so on this thread. If you have any questions or concerns with the solution(s) I selected please let me know by replying to this post.

Learn more about Accepted Solutions here.

Thank you!