FIND & APPEND tool vs JOIN tool

Question

I am using FIND & APPEND tool on the basis of ID which is a V_W string to combine two datasets. I also tried using JOIN tool instead for the same purpose however I am able to see that JOIN tool always returns more records than FIND & APPEND tool.What could be the reasons?

philipmannering · Answer

Both are valid options. It depends on what output you expect. If you share some sample/dummy data of your two inputs and the output you expect then I'm sure I can help.

omkarshinde · Answer

i have one table with unqiue numbers in one column and another column has IDs which can be repetitive but every record of this table is unique basically u wont get number and id combo duplicated and I have another table with IDs so now I want to combine both these tables for which i tried to use Find and replace tool(append) and Join tool once.
Is there better way to combine this data?

philipmannering · Answer

You said "FIND and Append" - I think you mean "Find Replace"...

In any case, the Join Tool is returning more records because you have duplicates on what you're joining on. The Find Replace Tool will just find a single match (similar to a vlookup in Excel).