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!