Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

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

Tejas_Puranik
5 - Atom

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.

3 REPLIES 3
Luke_C
16 - Nebula

Hi @Tejas_Puranik 

 

How's something like this?

 

Luke_C_0-1659382738672.png

 

 

Tejas_Puranik
5 - Atom

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
16 - Nebula

Hi @Tejas_Puranik 

 

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

Labels