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

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.

Unified_Daily_UE_Reporting_90Days.yxmd

Error Message

Join

Accepted answers

BenMoss

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

All comments

BenMoss

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?

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703