Need help with dropdown & action tool connecting to filter tool

Question

Hi All,

Below is an example table.  Could you please advise on how to use a dropdown tool for "Region" connecting action tool and filter tool ?
1. So from this table,  How to get an output for a specific region or all region - based on my selection in dropdown ?
2. Further if i use render tool (xlsx). How to make the output file name dynamic ? based on my selection in dropdown. Example : Consumption Asia.xlsx or  Consumption Africa.xlsx

MonthsProductsQty RegionJanRice100AsiaFebWheat200AfricaJanBarley300EuropeMarMillet400N. AmericaFebWheat500S. America

Thanks in Advance!

dreldrel · Answer

For the second point, you can specify your file name in a formula tool right before the output tool. Then use the interface tool to update this formula tool

KGT · Answer

And this is a basic app that shows how to do this. Note the selection on the output tool to change File/Table Name. You can use a formula beforehand to construct the entire qualified output name if you like.

Also noting in case you're not aware: To use the interface tools, the workflow will need to be an analytic app (yxwz file). Depending on whether this is for local consumption or gallery publishing, as to how you will configure the output tool location.

App to select region and output sheet.yxwz

caltang · Answer

On your second question, refer here:

* https://community.alteryx.com/t5/Engine-Works/How-to-Render-to-Multiple-Named-Excel-Sheets/ba-p/1015093
* https://community.alteryx.com/t5/General-Discussions/Automatic-add-date-in-filename/td-p/1143466