community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Find and Replace VS Join Tool

Hi all-

 

I am new to Alteryx and am in the process of studying for certification. Within the training video "VLookUps with Designer", the very last thing they talk about when differentiating Find and Replace functionality with Join is the find and replace returns a single match while join returns all identified matches. This is confusing to me because my understanding is that find replace can use a lookup table to replace multiple words or characters with their specified replacement, so I'm not getting why it says a single match is returned? 

 

Here is the link to the video i am talking about: https://community.alteryx.com/t5/Interactive-Lessons/VLookUps-with-Designer/ta-p/80201#done

Go to "To join, or not to join" and you will see the instance im referencing. Thanks!

Alteryx Partner

Hello @maddiecracken1 ,

 

what it means is that you can only have one word non repeated on the find lookup table.

 

Lets say you are looking for the word 'two'

Original data:

Aone
Btwo
Cthree

 

twoX
twoY

If there is more than one 'two' value (here is one for x and one for Y) on the find table only one will be showed.

 

On the join tool on the other hand you can join on multiple values but they will multiply, getting the following output:

 

Aonenull
BtwoX
BtwoY
Cthreenull

 

Hope I have explained myself well enough, sorry but english is not my native language.

 

Cheers

 

 

Labels