Both left and right inputs must have connections (Join tool issue)

[MonaAlmutairi]

Hello everyone,

I'm using SAP (ASC table) as a data source, but sometimes there is no data (depending on the target department and period). So, it causes a "both left and right inputs must have connections in the join tool".

I don't know how to fix this issue, with knowing that there is another join tool after the first one (and it always receive data in Right input)

For now, I just temporarily tried to input in the second join an empty text input with the same expected headers (it worked with empty text input but not with another tool with empty dataset :D) 

how to automate this process? I want my workflow to change the path to the one with empty text input if there is an empty data caused from the SAP.

Thank you.

[Felipe_Ribeir0]

Hi @MonaAlmutairi 

I believe that if you union a text input with the SAP input, having the same expected headers, it will work.