Hi all, I am new to Alteryx and am having trouble figuring out what tools to go about a probably very simple thing. What I am trying to do is input an excel file that will flag it if two DISTINCT entries from one column share the SAME entry in another column. For example, I want to build a workflow that will recognize and either 1) return the conflicts in red from the input below because in the second column the entry "B" has various source values (type 1 and type 2 and type 4) in a prior column or 2) add another column that flags a row as a conflict or not
Input File:
| Source | Target |
| Type 1 | A |
| Type 1 | A |
| Type 1 | B |
| Type 2 | B |
| Type 2 | C |
| Type 3 | D |
| Type 3 | E |
| Type 4 | B |
Desired Output:
| Source | Target |
| Type 1 | B |
| Type 2 | B |
| Type 4 | B |
OR
| Source | Target | Result? |
| Type 1 | A | not a conflict |
| Type 1 | A | not a conflict |
| Type 1 | B | conflict |
| Type 2 | B | conflict |
| Type 2 | C | not a conflict |
| Type 3 | D | not a conflict |
| Type 3 | E | not a conflict |
| Type 4 | B | conflict |
Any guidance is very appreciated!
