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.
