community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

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

Tejas_Puranik
5 - Atom
‎08-01-2022 12:23 PM

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.

Preview file
10 KB
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

3 REPLIES 3
Luke_C
17 - Castor
‎08-01-2022 12:39 PM

Hi @Tejas_Puranik 

 

How's something like this?

 

Luke_C_0-1659382738672.png

 

 

New Workflow5.yxmd
Reply
Tejas_Puranik
5 - Atom
‎08-01-2022 01:02 PM

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. 

Reply
0 Likes
Luke_C
17 - Castor
‎08-01-2022 01:05 PM

Hi @Tejas_Puranik 

 

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

Reply
Labels