Join Multiple with one data source in disabled Tool Container

Question

I have three data sets that I want to join.

I want to build workflow that joins only from the enabled tool container.

Is there a way to join the datasets that are from enabled tool container?

I don't want to manually remove the connection string and want to make it dynamic because I will be using and rolling over for multiple periods.

joinMultipleQuestion.yxwz

binu_acs · Answer

@hlee36 The join tool required the values from the connected input tools, so don't think your approach will work, another alternative to your approach using the union tool and then transpose and cross-tab the data

joinMultipleQuestion.yxmd