Join without multiplying the data

Question

Hello there,

I'm trying to find the solution for my work flow. I'm not sure someone already touched this topic as I can't find any previous solutions for this so I'm seeking for your expertise.

I have for example 2 sets of data below:

And I want the result comes out like this:

If I do the JOIN, it will end up multiplying the data (see result below) and I'm struggling for a solution. Does anybody already deal with this issue before? I'm very much appreciated for your help!

Many thanks in advance.

asi_272829 · Answer

Hi all, thanks a lot for your helps.

flying008 · Answer

Hi, @asi_272829

Another way is so easy for you:

The Join tool detail set as @hlee36 said above.

hlee36 · Answer

The simplest way to solve this issue would be using the tile tool as below.

The reason why the multiplication of data happens is due to the lack of a unique identifier when joining two datasets.

"ID" in both tables are not "unique" because ID of 2 has a def value of b, c and d in table A and ID of 3 also has multiple values e and f.

To solve the problem of not having a unique identifier, we can use tile tool to make another field and assign values to each row.

Then, the combination of two attributes (ID and Tile_SequenceNum) will be a unique identifier so that only one row can have one combination of ID and Tile_SequenceNum in both Tables.

Then, we can join two tables using our unique identifier as below.

We can now drop the Tile_Num and Tile_SequenceNum that we used to combine these two tables. But, feel free to keep them if you may need them.

JoinTile_Solution.yxmd