Forum Discussion

JensDeveloper's avatar
JensDeveloper
Contributor II
2 years ago
Solved

error 3 upstreams for join

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.


My three inputs:

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

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

    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!

     

2 Replies

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

    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!

     

    • negi_sagar's avatar
      negi_sagar
      New Contributor II

      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.