cancel
Showing results for 
Search instead for 
Did you mean: 

error 3 upstreams for join

JensDeveloper
Contributor II

Hi all,

I am trying to use the join snap with 3 inputs. The solution works when I use two joins after each other but now I wanne try if it's possible to use only one join with three inputs.
I always get the error: failure: Right join path not found for input2, Reason: Right join path is required, Resolution: Please address the reported issue.

But the mapping is looking right to me.

JensDeveloper_0-1724057728518.png
My three inputs:

JensDeveloper_1-1724057784240.png

Pipeline in the attachment with the dummy data (change the extension from .json to .slp and upload it into your designer)

1 ACCEPTED SOLUTION

koryknick
Employee
Employee

@JensDeveloper - please refer to the following in the Join snap documentation:

koryknick_0-1724066221618.png

Basically, you need the same join criteria on each input view.  In your case, you can add a Mapper in the top path to add a null-valued $ad_department, and another Mapper on the bottom path to create a null-valued $ad_company.

Hope this helps!

 

View solution in original post

2 REPLIES 2

koryknick
Employee
Employee

@JensDeveloper - please refer to the following in the Join snap documentation:

koryknick_0-1724066221618.png

Basically, you need the same join criteria on each input view.  In your case, you can add a Mapper in the top path to add a null-valued $ad_department, and another Mapper on the bottom path to create a null-valued $ad_company.

Hope this helps!

 

My team is facing the same issue. We did what you said by making the columns consistent but it is still giving us the same issue. 
Can you edit this pipeline and tell what exactly is changed.
<Just change json to slp>
It is a small pipeline with the sample data or 2 rows.