Join function

[KA]

Hey, Can someone help me in understanding why I there are no records showing for my left and right join. 

[ShankerV]

Hi @KA 

I have taken a look at the workflow.

You have used to join 2 sheets from same excel sheet containing different schema.

Answering your question, if there is no data's left out in L and R node, then you do not have any unmatched rows pending.

Many thanks

Shanker V

[ShankerV]

Hi @KA 

To explain more with example, 

Input 1:

Input 2:

You can see there is one unmatched item in Input 2, where Venkat is not present.

Hence L node will have the unmatched items from Left Input.

Venkat will be there

J node will have all matched items from left and right input.

R node will have the unmatched items from Right input.

Output: L node:

J node

R node:

Please shout out if you need further more clarification.

Many thanks

Shanker V

[ShankerV · Accepted solution]

@KA 

Found this diagrammatic representation in the below link for our better understanding.

https://help.alteryx.com/20221/designer/join-tool

Hope your issue is resolved. Feel free to mark helpful answers as a solution, so that future users with the same issue can find them easier!!!!

Many thanks

Shanker V