Merge Unique Ids. One data has 33 Unique Ids and another data has 24.
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Join
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This is such an amazing community!! @jdminton @Rana_Kareem @Alayna Thank you soo much :)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 😊