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 alw...
  • koryknick's avatar
    koryknick
    2 years ago

    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!

     

koryknick's avatar
koryknick
Employee
2 years ago

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
9 months ago

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.