Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

SOLVED

Enabling Disabling Containers based on a Condition

skotian1289
8 - Asteroid

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

 

afv2688
15 - Aurora
15 - Aurora

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:

 

Untitled.png

 

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

skotian1289
8 - Asteroid

@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

afv2688
15 - Aurora
15 - Aurora

Hello @skotian1289 ,

 

thank you for your comments 🙂

 

I have switched the app to automatically select the country based on the data entry. The problem is that if you are inputting data from two different countries there would need to be some input to select the country.

 

Before using the app delete the filter on the app, I just had it there to switch and select the data for testing.

 

Regards

skotian1289
8 - Asteroid

@afv2688 - How about if I create multiple filter streams example: Field1=FRANCE and Field1=GERMANY and so on in the "Select Process" canvas and connect those individual filter tools with the macro logic you provided, this way everytime a different file is extracted by tool it will automatically run that specific stream and generate output and since rest of the stream will have all False data it will automatically not create any data ?

 

Do u think it is a good idea ?

 

Thanks

afv2688
15 - Aurora
15 - Aurora

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

Labels