Hi all,
I'd be grateful if you can help or give me a hint how I can determine Status Tracker using Alteryx.
Example below:
Thank you!
See attached. You just need to add another condition for nulls.
If this solves your issue, please mark this as complete.
Hi,can you please explain a bit more the difference between 1 and 2, I think I don't see the trick here.Thanks,Alan
You can essentially look for either the value "exempt" or "exemption" and create flags. From there, you can do a unique and then a sum of the flags.
When there is no other value than exempt or exception then we should have status 1. If the value was "In Scope" or Null then the Status should be 2.
echuong1 your solution almost work , except the situation with NULLs
