We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Find Replace x Join Tool

Jon_Taylor
8 - Asteroid

Why use the "find replace tool" over a "join Tool"


@MattD, this was a questions referring to this Tool Mastery article

2 REPLIES 2
BrandonB
Alteryx
Alteryx

Find Replace with the append option is similar to a join, but it is only finding one match and linking the corresponding data, similar to a vlookup. Joins are important when you need to link up data for every match in the second data set, not just one. Also, the find and replace tools requires a string data type to find where a Join tool can use strings to find in strings, or match numbers to numbers. 

danilang
18 - Pollux
18 - Pollux

hi @Jon_Taylor 

 

Another use for Find Replace is partial matches.  Join only matches full fields, whereas Find Replace will return partials.

 

Dan

Labels