Correlate two collumns

Question

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

Column AColumn BSelectionC1100001XC1100002XC1100002XC1100003XS1100001 S1200001 S1200002 S1200003 UA1100001XUA1100002XUA1100003XUA1100004XUA1100005

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.

CharlieS · Accepted Answer

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.