Alteryx Macro for allowing users to select columns

Question

Hi all,

I'm looking to create a macro tool that takes in data for multiple weeks but allows the user of the macro to select which weeks (columns) will remain. I want the Category column to always remain selected but give the user the option to select any number of week columns. I have attached an example of the workflow I'm trying to create. Currently, the macro is not correctly selecting which columns I want to remain in scope. If someone could please provide some guidance on how to make this work, that would be greatly appreciated!

Thank you!

SelectColumnsExample.yxwz

apathetichell · Answer

@taschmies --- when using an app the default is that no browse tools show output. You can configure which browse tools you want to show output via interface designer and configuring what to show when running an app.

fyi -> I'd use chained apps, app 1) loads file --- creates yxdb for app two column select. app 2 listbox with input from app1. listbox - action tool and then dynamic select with an IN statement. I just like dynamic select so much more than a list box in select mode.

binu_acs · Answer

@taschmies use the select tool mode from the list box

taschmies · Answer

Hi @binu_acs thank you for your example! This works correctly, but I'm not sure what change you made to get it to work. When I run the same example that I uploaded or try to apply this logic in my main workflow, I get the below error message