How to give multiple key columns in join?

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

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

Hey @Pretty,

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

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

@Pretty I meant from both paths

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