FIND & APPEND tool vs JOIN tool

[omkarshinde]

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]

Do you mean Append Fields Tool? I've never heard of the Join & Append Tool.

Also, I wouldn't have thought that the number of records output from a Join Tool would ever exceed the output from Append Fields Tool. Could you share a screenshot of both, showing the Connection Progress (check box in Canvas Workflow Configuration)?

[omkarshinde]

No, actually I meant FIND AND REPLACE TOOL(APPEND ANCHOR IN IT). Just to give you an idea, FIND and Append tool is returning 6197 records while join tool is returning 6265 records.

[PhilipMannering]

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).

[omkarshinde]

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]

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.