Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

Kritikagupta
6 - Meteoroid

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

5 REPLIES 5
Alayna
8 - Asteroid

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
9 - Comet

Hi @Kritikagupta ..

 

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

 

Like this:

 

Unique & Join Tools.png

 

 

Updated the attachment to make the data consistent.

 

 

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

jdminton
12 - Quasar

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
6 - Meteoroid

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

Rana_Kareem
9 - Comet

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 😊

Labels
Top Solution Authors