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

1 REPLY 1

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!