The quickest way to find out discrepancies between two columns

Question

I have data set like below

IDCOL ACOL B1AAABBB2BBBCCC3CCCZZZ4DDDFFF

I want the delete the line that if COL A value exist in COL B or  COL B value exist in COL A

so for ID 1  BBB existed in Col A  so it is deleted. for ID 2 BBB existed in COL B deleted. ID 3 CCC existed in Col B so it is deleted.

the result i want is only

4DDDFFF

what is the quickest way to implement this?

AZuc · Answer

@187

I've built this approach here to practice a little bit on Make Group tool. I'm not sure how it will work with more data. It needs further testing.

JustForFun.yxmd

AZuc · Answer

@187

If ID is not Unique then add a Record ID tool before Transposing and use this key in the final join.

187 · Answer

Thanks for your quick solution, what if the first column ID is not unique? i saw you use join here