Is there a tool similar to Fuzzy Match that enables you to "Match" data between columns on the same row?
Hi @hubyh, there isn't, but using the transpose tool will allow you to move those columns onto different rows, allowing you to use the fuzzy match tool
Hi @hubyh
If i understood well what you are trying to do, with some work you can adapt this use case: https://community.alteryx.com/t5/Alteryx-Use-Cases/Fuzzy-Match-Check-Row-by-Row/ta-p/270809
Hi @hubyh
Check the attached example. You just need to stabilish a value 0-100 that is acceptable as a match. I would use 70.
User | Count |
---|---|
63 | |
26 | |
23 | |
21 | |
21 |