cancel
Showing results for 
Search instead for 
Did you mean: 

How to give multiple key columns in join?

Pretty
New Contributor III

I have multiple tables and I need to join them all with different key columns by using the join snap, but it is resulting in the following error:-Failure: Right join path not found for input2, Reason: Right join path required, Resolution: Please address the reported issue.

image

Below you can see the screenshot that we are joining with different key columns
image

Please help me how can we do the join with different key columns?

5 REPLIES 5

bojanvelevski
Valued Contributor

Hey @Pretty,

Try and exclude the .get() function while defining the fields.

Pretty
New Contributor III

@bojanvelevski
Even after exclude the .get() function I am facing same error

image

bojanvelevski
Valued Contributor

@Pretty I meant from both paths

rajesh_mangipud
New Contributor II

The Join Snap does not work the way you are trying to do the Joins. Instead have multiple Join Snaps one after the other.