08-19-2024 02:02 AM
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)
Solved! Go to Solution.
08-19-2024 04:19 AM
@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!
08-19-2024 04:19 AM
@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!
Monday
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.