Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

If conditional formula error (Tax Codes)

NehaNevrekar
8 - Asteroid

Hi Team,

 

I am trying to apply an 'If' conditional formula in alteryx to check the tax codes with 5 other columns. However, I am not getting the result as expected.

 

I am attaching the sample data and the workflow I have prepared. 

 

Would appreciate an immediate reply.

 

Thank you!

 

Attachments

  1. Input data
  2. Workflow
  3. Output file (Errors highlighted in red)
  4. Actual Tax codes conditions
3 REPLIES 3
Raj_Singh1
9 - Comet

HI Neha @NehaNevrekar 

 

 

Please see attached solution workflow and screenshot. hope it works, if not then please let me know. I have only added extra brackets for or condition as you want all of them to go together. but if it still doesnt work then please let me know..

tAX ERROR.png

 

 

NehaNevrekar
8 - Asteroid

Hey Raj,

 

Thanks a lot. It worked for me.

 

Regards,

Neha

Raj_Singh1
9 - Comet

Thanks for accepting as solution 🙂

Labels