Workflow to determine if DISTINCT values in 1 excel column have COMMON values in another?

[NewToAlteryx123]

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! 

[BRRLL99]

Hi

Can you show your Expected Output

[NewToAlteryx123]

Just did!

[flying008]

Hi, @NewToAlteryx123 

Is this your want ?

The summarize option: Group by [Target], Count Distinct  by [Source]

******

If it helped you to solved, maybe you can  accept it as a solution and give a like to answer.  

[Qiu · Accepted solution]

@NewToAlteryx123 
A quick one.
Summarize tool has the function to count distinct record, so we can use it to flag out our targets.

[NewToAlteryx123]

Hi, wow thank you so much! do you have the .yxmd so I can see the configurations?