Join tool error

[avuong6]

i have this work flow that takes some parameters and dynamically updates my sql based on the selection:

its the same query but connected to different environments. and as it is works. the results are saved to an excel spread sht.

i then remove the output and merge the 2 queries into a join tool.

When i look into the join tool to specify join by specific field, there is nothing in the drop down to select:

when i hard code the sql and use the join tool, it works. 

so not use what i m doing wrong in making the sql dynamic that breaks the join tool. any ideas would be appreciated.

[ericsundby]

Not sure if this will work but try right clicking each one of the input tools and selecting "cache and run workflow" then re-attach the join tool and see if that works.

[acarter881]

Hello @avuong6. What are the errors on the Input Data tools? This is a guess, but it may be a metadata issue (which may help explain why you don't see any fields to choose from in your Join tool).

Have you tried leaving the Output Data tools on the canvas as well as the Join tool? I believe you should be able to write your outputs and perform your join with one press of the Run button.

[avuong6 · Accepted solution]

not sure what happened but i was able to get the in database workflow working. thx for the tips.