community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Correlate two collumns

I have a file with over 70 millions lines and I want to correlate two columns with some inputs

 

Column AColumn BSelection
C1100001X
C1100002X
C1100002X
C1100003X
S1100001 
S1200001 
S1200002 
S1200003 
UA1100001X
UA1100002X
UA1100003X
UA1100004X
UA1100005 

 

I would like to relate every line that has the same info of Column B  between C1 and UA1. So I wouldn't have none of S1 on it only those who are C1 and UA1 with X.

 

I tried with the Unique tool but I didn't have success.

 

Alteryx Certified Partner
Alteryx Certified Partner

Hello @felipemorselli 

 

I've put together the attached example that shows one way this can be achieved. By the way, the UA1|100004 line in your example should not be selected according to your criteria.. Let me know if you have any questions about the suggested methodology. 

Hello @CharlieS !

 

Thanks for pointing the item that shouldn't be on my output file! It worked so fine!

 

Kind Regards,

Felipe M.

Labels