Run different workflows depending on the excel sheet name

Jmarquez

hello everyone, I am quite new to creating apps and would appreciate some help.

I am trying to create an app that will be shared within my and whose output will feed a dashboard every month.

the workflow will be fed from two excel files, both with different tabs and structures. But always with the same name for the tabs.

The idea is to create an interface where the app user selects the excel files and depending on the tab name it filters to run one workflow or another and the results are saved in the same excel output but in different tabs.

I have managed to do this when designing the workflows by adding each tab as a different input, but I am not able to make this selection  done automatically from the file that the user selects.

I attach an image of the workflow so far.

thanks in advance.

sample wf.png

MattBSlalom

As a concept, a Macro is just a workflow that we encapsulate to be used as a tool in another workflow.  For example, drag a Count Records tool from the Transform palette onto a canvas and right-click on it, then select "Open Macro...".  That will show you the workflow that exists inside that single tool.

Similarly, we're turning your workflow into a single tool (actually 2 tools in this case).  We need to split your workflow and save each half as a separate workflow / macro.  Then we need to replace your existing file input tools with the sample from my fake macro.  The Macro Input tool will convert the workflow to a macro & the Dynamic Input tool will allow us to pass the Excel file path at runtime (you can update the Input Data Source Template configuration of the Dynamic Input in each of your split workflows to be the expected structure).

Once you have your 2 macros saved, you need to use them in place of my fake macro calls in the parent App workflow from my previous reply.  There are a couple of ways to get a macro into your canvas (Macro help documentation) :

Option 1 - Add a tool palette to hold your macros

In Designer, you can map to the location where you save macros and create a macro repository to easily save macros and use them in a workflow. Any macro .yxmc file in the selected location displays in the tool category on the Tool Palette.

To create a macro repository...

1. Go to Options > User Settings > Edit User Settings > Macros.

2. Select the "+" button.

3. In Category Name, enter a name. The default name is Macros.

4. Select the "..." button to browse to the location where you save macros on your computer or a network.

Option 2 - Right-click, insert macro

To use a macro that is not on the Tool Palette, right-click the workflow canvas and select Insert > Macro. Any macro that is currently open on the canvas can be selected from this list or you can browse to the location of a different macro *.yxmc file.