Alteryx designer workflow assistance

Question

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 NumberModel NumberManufacturerTask ListGroup CounterEqui1xxxxGE1231Equi1xxxxGE4561Equi2xxxxGE1231Equi2xxxxGE4561Equi3zzzzZamil7892Equi4zzzzZamil6702

ChrisTX · Answer

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