This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
What you have is what we in the 'biz' call a multi-dimensional join. If Input 1 has 10 IDs that are 16164 and Input 2 has 20 IDs that are 16164, and you join them together, your computer is not quite sure what belongs where. As a result, each of your 10 identical IDs in inpur 1 will each be assigned the 20 records in input 2, resulting in 200 joined records! If you find your records growing in a join, look for this behavior.
What you should try doing is going to input data 2, make sure that instead of 20 idential IDs, they are all unique. Hence the unique tool in my solution! Check it out!
I also added afun trick join if your ever wanted to join by position which worked in this case as well (but probably won't in real life).