Enabling Disabling Containers based on a Condition

Hello All,

I am not sure if it is a silly question but I need assistance to solve this issue.

I have built a tool which has 3 different workflows for 3 different sales regions and all 3 workflows has a similar Input tool. The input file are named as "USA Sales.csv" "Germany Sales.csv" "France Sales.csv" and for all 3 regions I have created a seperate workflows because the file format and logics are diiferent, so we have Workflow 1 for USA, Workfow 2 for Germany, and Workflow 3 for France and every workflow has a email tool which sends out email to their respective sales team. I have setup a condition saying if the Filename has word "USA" then the file will be directed to Worklflow 1 or if it has "Germany" then it should be directed to workflow 2 and so on.

My problem is everytime is run the tool all the 3 workflows runs and other 2 throws a error. I want to enable Diable my workflows based on same file name condition that if File name contains word "USA" then only workflow 1 should be enable and other 2 should be disabled and if File name contains word "Germany" then only workflow 2 should be enabled and other 2 should be disabled.

Is it possible to achieve this result in alteryx?

Sahil K

Dynamic Processing

Data Investigation

Accepted answers

afv2688

Hello @skotian1289 ,

This is a quick demnostration in which by selecting on the dropdown what country you wanna process you can add the tools and the configuration you want as required:

Within the macro, each process is saved inside it's corresponding macro. By selecting what country do you want to proceess, it enables or disables, depending on your selection.

Hope this helps.

If you have any further questions or doubts about it please let me know.

Regards

Select_process.yxzp

afv2688

Hello @skotian1289,

To avoid any problems, and to ease the proces, you just need to remove the filter tool on the app (do not touch the macros). Since the values are entering into a batch macro, the flow will process the information country by country:

- France data goes through france proces

- Usa data goes through Usa process

- etc

The results will be shown in the end toghether, like they were joined with an union tool.

If the amounts of columns don't match or you want them to be shown on different reports please let me know and I will do the adjustments.

Regards

All comments

afv2688

Hello @skotian1289 ,

This is a quick demnostration in which by selecting on the dropdown what country you wanna process you can add the tools and the configuration you want as required:

Within the macro, each process is saved inside it's corresponding macro. By selecting what country do you want to proceess, it enables or disables, depending on your selection.

Hope this helps.

If you have any further questions or doubts about it please let me know.

Regards

Select_process.yxzp

skotian1289

@afv2688 - You are a genius, your technique works.

Just a small issue though with your technique the user will have to go open the workflow and select the specific option in Macro tab and then run the tool, what if is it is a scheduled workflow or the tool is automatically picking up the input file from a specific folder, do u think tool will be able to decide on its own based on File name which Macro option to select ?

Thanks a lot

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703