Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Correlate two collumns

felipemorselli
6 - Meteoroid

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.

 

2 REPLIES 2
CharlieS
17 - Castor
17 - Castor

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. 

felipemorselli
6 - Meteoroid

Hello @CharlieS !

 

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

 

Kind Regards,

Felipe M.

Labels