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.
Hello, I have a situation that may be difficult to describe. I am working with a data set that requires having two outer joins in a row. The first join has a simple, basic [key]. In the second outer join, I tried joining on just [key], but I am missing some data in the join. Joining on the [key] and then adding a second key on the [key] and [right_key] seemed to pull in the data I needed. I use the unique tool later in the workflow to filter out any duplicates.
I’m wondering if my approach makes sense, or if there is another solution to missing data records when doing multiple outer joins in a row.
Thank you for your response. It appears I was joining on the incorrect key in the second outer join (I renamed the required key right_key in the first outer join). Once I updated the second key to be just right_key,key I got the required results. The second key on just key,key was not required.