Hello,
I created a workflow which when run allows the user to select a file located on a LAN or on their computer and then outputs (writes) that location and file name into a cell in a temporary Excel document. Where im stuck is i have multiple workflows that will be run one after the other that will need to take that input file from the cell in the excel document and use that in an Input Tool or some other input to make that excel document and tab accessible to the workflow.
Let me give you an example to make sure i have given you a clear message.
Workflow A (analytic app) when run asks the user to select a file. This workflow writes the location and file name that the user selected to a temporary excel document called, "variable.xlsx" and places it on tab "var". We will call this the "Variables" file. The variable file is written to a temp location that is accessible repeatedly until it is overwritten or deleted.
An example of this file location and name which the user would select is:
"C:\Alteryx\Rates\Prices_08-31-2019.xlsx" we will call this the "Rates" file.
This file location and name is written to the Variables file on the var tab in column 2. That was the easy part for me.
From here i have about 12 workflows that will be run one after another but each of the 12 workflows will need to reference and input the rates sheet. To make thing even more complicated is the Rates sheet has one tab per each workflow that will be run.
An example of the tabs are:
Branch Office A
Branch Office B
Region A
Region C
etc...
So basically when the BranchOfficeA workflow runs i need it to open the Variables file get the file name and then get the data from the Branch Office A tab. Then BranchOfficeB gets Branch Office B tab etc. It is the input that im stuck on here. essentially i just want to make the input variable.
I hope i didnt confuse anyone here and i really appreciate your assistance on figuring this one out.
