Find Replace and Join

[sheilaarman]

Hello-

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? 

[atcodedog05]

Hi @sheilaarman 

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

Join tool

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 : )

[ellen-wiegand]

Find and Replace also can search within a field, whereas join the fields have to be an exact match