Alteryx designer workflow assistance

[Areej_Abed]

I would like to have a workflow that looks for different equipment number with the same Model number and same manufacturar but different Task List or differnt Group Counter.  

As shown in the table the first 4 rows (Equi1 and Equi2) should not be highlighted as an exception because the first row is matching the third and the second is matching the fourth.  

The fifth and the sixth rows (Equi3 and Equi4) should be shown as an exception because they have same Model number and same manufacturar but different Task List.

Equipment Number	Model Number	Manufacturer	Task List	Group Counter
Equi1	xxxx	GE	123	1
Equi1	xxxx	GE	456	1
Equi2	xxxx	GE	123	1
Equi2	xxxx	GE	456	1
Equi3	zzzz	Zamil	789	2
Equi4	zzzz	Zamil	670	2

[ChrisTX]

Try the RecordID and Join and Formula tools .  Use an IF function in the Formula tool.

If you're just starting to use Alteryx, check out the menu at the top of this page, under

Learn > Academy > Learning Paths and 

Learn > Academy > Interactive Lessons

Join the dataset to itself. on Equipment and Model, use an IF function to create a new field like "This record flagged", type Boolean:

IF [RecordId] != [RecordId2] and ([Task List] != [Task List2] or [Group Counter] != [Group Counter2]) THEN 1 ELSE 0 ENDIF

You may also need a Unique tool to ensure there are no duplicates on RecordId and RecordId2.

Chris