More row after using join tool

Question

Dear community,

i have one question which i dun really know the reason on it.

In my original file , there is only 117825, but after i use join tool, it increase 751670. as per screenshot below.

Original file

After using join tool

May i know why it increase? It should decrease since we use the inner join function in this case.

gabrielvilella · Answer

Hey @SH_94, you can find the Unique tool under the Preparation category:

And the Summarize under the Transform category:

You can place one of them before the Join tool. Here is an example withe the Unique attached to the database that has duplicates on the key field:

binu_acs · Answer

@SH_94 @messi007  suggested there might be duplicate records in your input file. you can search for the unique tool in the search option

SH_94 · Answer

HI @messi007 ,

May i know where i can find the unique tools?

Thank you'