Find Replace x Join Tool

[Jon_Taylor]

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


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

[BrandonB · Accepted solution]

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]

hi @Jon_Taylor 

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

Dan