Alteryx Macro for allowing users to select columns

[taschmies]

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!

[binuacs]

@taschmies one way of doing this

[Qiu]

@taschmies 
How about we place another Select tool before the List tool and unselect the Category column so it will not go to the selection list.

[taschmies]

Hi @binuacs 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

[binuacs]

@taschmies use the select tool mode from the list box

[apathetichell]

@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.