This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!
I have just began learning Alteryx and I'm enjoying it.
Find replace and join is something I'm still trying to fully grasp. What is an example of when you would use one vs the other?
Find and replace
1. Works like excel vlookup (left full join).
2. You can search for a text in a the column and replace it or add a column.
Limitation: Can map on only one key column
1. Can map on multiple key column
2. Default gives inner join with help of union tool we can left full and right full join.
Limitation: has the possibility of doing many to many to join and causing data explosion.
Hope this helps : )
Find and Replace also can search within a field, whereas join the fields have to be an exact match