Disregarding certain data types in workflow

Question

Hi all

I run a departer process for our firm, and have come across an issue where I need to 'disregard' a certain process type.

To explain (see attached sheet)

* John Smith is a Contractor and moving to full time employment
* According to our employment system his 'contractor' staff profile has to be terminated (Business Process Type = "End Contingent Worker Contract" and has to be re-hired (Business Process Type = - "Hire")
* Transaction Status will always be "Successfully Completed"
* Hire "Effective Date" will always be after the End Contingent Worker Contract "Effective Date"

The problem is i need to totally disregard re-hires in this format, as they're not 'leaving the firm' like an ordinary departer, they're just changing employment status so do not need to be picked up by our process.

I am hoping someone with a lot more experience with Alteryx Designer can help me to work out how to do this ?

Contractor vs Re-Hire.xlsx

StephenT · Answer

Unfortunately i can't exclude the 'End Contingent Worker Contract' field in general as I still need to monitor contractors leaving the firm, where their contract has expired or been terminated.

The problem we have is some/most contractors are terminetd in our system then re-hired as Full time Employee therefore I I need to  'ignore' any contractor departures where their 'business process type' shows in our reports as 
"End Contingent Worker Contract" then followed by "Hire" based on the 'effective date (or departure)', as this indicates that they have gone from 'contractor' to FTE (full time employment).

GJNom · Answer

Hi Stephen,

You can use Filter tool and write the expression for Business Process Type column to exclude where the cell says End Contingent Worker Contract.

I think this is what you're looking for as far as I understand your question. If not, please elaborate the problem you're facing.

mceleavey · Answer

Hi @StephenT ,

I don't see an example of the second scenario.

M.