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.

Detour Help.yxmd

Gaurav_Dhama_

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.

Detour Help.yxmd