How to give multiple key columns in join?

Question

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.

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?

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?

rajesh_mangipud · Answer

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

bojanvelevski · Answer

Hey @Pretty,
Try and exclude the .get() function while defining the fields.

pretty · Answer

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

bojanvelevski · Answer

@Pretty I meant from both paths

sri4 · Answer

Is there any cleaner way to join more than 2 tables?&nbsp;

Forum Discussion

How to give multiple key columns in join?

5 Replies

Recent Discussions

401 error with HTTP Client and NTLM

Pagination and nextCursor in header

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working