Join Error: Both left and right inputs must have connections.

[nisarg205]

I am trying to join two inputs 1: Dynamic Input that collects data from SQL server and 2: Data from Sales-force. I am getting " Join (32) Both left and right inputs must have connections." error . I do not have any missing links in the workflow and therefore I am not able to find the root cause.

[BenMoss · Accepted solution]

It looks like you have got a series of dynamic inputs before the join, can you be sure these files are flowing through appropriately and there is no read errors?

Ben

[nisarg205]

Solved. You were right, though there wasn't any read error, but in one of the dynamic inputs I wasn't reading anything. Actually, the alteryx filter continues the flow though the filter condition is false. Is there a way to just stop the flow from processing further if the condition does not match except the count record and union solution?

[BenMoss]

Okay, it's annoying that it's not throwing a read error though!

Check out the 'test' tool, and also within the crew macro pack, there are a series of easily configurable test tools https://community.alteryx.com/t5/Engine-Works-Blog/Crew-Macro-Pack-2016-Q2-Release/ba-p/26482 that may be useful!

Ben

[Number4]

Just thought I'd add what was causing this issue for me, to help others on what to look for.  Relating back to the marked answer.

I had a container, four joins back in the workflow which I'd meant to collapse with the down arrow (allowing it to still run.)

Instead, I'd collapsed it with the blue box, disabling it.

[NabilA]

omg... I've been stressing over this the last 30 mins... at least now I know you can switch a container off!

[MarinaKim]

Hi, for me the issue was in another join tool I accidentally deleted the connection from. Hope this will help somebody to save some time.