Merge Unique Ids. One data has 33 Unique Ids and another data has 24.

[Kritikagupta]

Hello Community,

I am trying to merge 2 set of data one with 33 unique Ids and one with 24.

When I merged, it is still coming to 33. I am not sure where I am going wrong here.

I would appreciate any help.

Thanks

Kritika

[Alayna]

Hi @Kritikagupta 

There's an option in the multiple join tool where you can only outputs records that join inputs. That should get you your 24 records.

[Rana_Kareem]

Hi @Kritikagupta ..

The best practice when dealing with duplicate values is to use Unique tool before Join Tool.

Like this:

 

Updated the attachment to make the data consistent.

If you have any questions, feel free to ask..

[jdminton · Accepted solution]

You are actually only getting 24 with complete data. If you look at the joined data, you will see NULL values for the sleepDay activity since not all 33 IDs are included. Your data is correct as it is. If you just want to see those where values exist for all fields, use two regular join tools or select the option "Only Output Records that Join from All Inputs" in the Join Multiple tool.

[Kritikagupta]

This is such an amazing community!! @jdminton @Rana_Kareem @Alayna Thank you soo much :)

[Rana_Kareem]

You’re welcome,,

Glad to see that your issue has been resolved.

If my answer was helpful, you can also accept it as a solution 😊