Compare value from a column with all the values from other column and find the difference.

[Tejas_Puranik]

Hi All, I'm new to Alteryx.

I have two columns Column A and Column B, Column A has values that are similar to Column B as well as some additional values that do not match with column B. I want to filter out all such values that are not present in any of the rows in Column B. Please see that attached sample data set for your reference. I used these formulas: Contains([Column A], [Column B],) and [Column A] = [Column B], but these are only comparing the adjacent row value. Please suggest a better solution to solve the problem. FYI there are approx. 20K records. Thanks in advance.

[Luke_C · Accepted solution]

Hi @Tejas_Puranik 

How's something like this?

[Tejas_Puranik]

Hi @Luke_C Thanks ! this has given me a good start but I also found some matching values in the final results. I would like to filter only the once that are not matching. Thanks for your help. 

[Luke_C]

Hi @Tejas_Puranik 

Then what you said for Column A = Column B would work in a filter tool.