Join without multiplying the data

[asi_272829]

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.

[FrederikE]

Hey @asi_272829,

This is quite interesting. You require the Join tool to do a mix of Joining on ID and on Record Number.

I was able to build this using a batch macro - this might be overcomplicated but it works.

[Raj]

Simple and efective

Hope this help

[hlee36]

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.

[flying008]

Hi, @asi_272829 

Another way is so easy for you:

The Join tool detail set as @hlee36 said above.

[asi_272829]

Hi all, thanks a lot for your helps.