Question regarding detour tools

[michalikm]

Good day,

I have a fairly complex workflow that I am attempting to update that uses several different input files (based on interface options) and can output multiple output files (also based on interface options). Within the workflow, one of the interface options allows the user to input an excel file, compare that file against a large database, and outputs a revised version of the input that captures any changes found within the live database. 

Where I'm running into issues is that the Input.xlsx is also used to feed several other parts of the workflow that help create other output files. My ask is that when the user selects the interface option that is creating the revised input (output file), I want to route that data to feed the remaining functions of the workflow instead of it using the data within the original Input.xlsx file.

I've done my best to recreate a smaller sample (below/attached) to show the environment. I've been attempting to solve for this using a detour tool, but I think I'm on the wrong path. Any help would be greatly appreciated.

[pstrasser]

Hello! Have you considered using the interface tools to turn on/off containers to solve the problem? Potentially something like this: 

[abacon]

@michalikm In this case, detour tools would not be your best option. @pstrasser Option for disabling containers using the interface tools is the best bet here.

Detour tools are for running separate functions on data streams based on a criteria then bringing them back together to run into the next piece of the workflow.

Bacon

[Gaurav_Dhama_ · Accepted solution]

How i would do it is by attaching a detour end before the summarize. Now detour end can only accept one live connection, so add select tools before both its input, put them in individual containers and then control these containers. As shown below. What we are essentially doing is breaking the flow. Now you already have an input that user is either selecting or adding, use that to correct turn on and off the containers. Refer the screenshot below.

Edit 1: Attaching the workflow as well. Let me know if this is not what you are trying to achieve.

[michalikm]

@Gaurav_Dhama_ This worked perfectly, thank you. I didn't think to use the detour end only, as it always gave me an error message that a detour start tool was required.