Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Find Replace and Join

sheilaarman
5 - Atom

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? 

2 REPLIES 2
atcodedog05
22 - Nova
22 - Nova

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
Alteryx
Alteryx

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

Labels