topic Matching across variables in Alteryx Designer Desktop Discussions

Matching across variables

Hong_Hu — Mon, 04 Aug 2025 16:47:27 GMT

Hi, I have a dataset with two phone numbers and I'd like to find records with matching phone numbers regardless if it's the first or the second. For example:

Record# Phone1 Phone2

1 123456789 111111111

2 222222222 123456789

I'd like to say record 1 and 2 is a match

What could you do to find that match? Thanks for any suggestion!

Best,

Hong

Re: Matching across variables

binu_acs — Mon, 04 Aug 2025 17:25:06 GMT

@Hong_Hu may be Find and Replace tool is an option

Re: Matching across variables

Hong_Hu — Mon, 04 Aug 2025 17:53:54 GMT

That's a great solution, thanks!

Re: Matching across variables

Qiu — Tue, 05 Aug 2025 00:57:18 GMT

@Hong_Hu
I would think a bit more complicated case though I am not sure whats your real data look like.

Re: Matching across variables

Hong_Hu — Tue, 05 Aug 2025 14:01:22 GMT

Wow Yes this is exactly what I need. Thanks!