Dummy Variable Application

[mcdevittp]

Hi Everyone, 

I'm new to Alteryx and getting caught up on application building. 

In short, for practice, I am trying to create an application in which you load a data set, select your categorical variables, and it produces the data with dummy variables. Similar to the python command getdummies(). To do this, the user needs to select which which columns are categorical and I cannot for the life of me figure out how to update a value in the pivot table. 

I have used this post to make the dummy variables: https://community.alteryx.com/t5/Data-Preparation-Blending/Creating-dummy-variables/td-p/34780

And this post to try and debug the issue (I can't find the "Update Select with Multi-Select List Box' option): 

https://community.alteryx.com/t5/Alteryx-Connect-Gallery/List-Box-Select-fields-to-display/td-p/2813...

If anyone could point me in the right direction i would be forever grateful. I'm loving alteryx btw. File Attached. 

[SophiaF · Accepted solution]

@mcdevittp - if you add a Select tool just before the Transpose, you can then connect the Action tool to that Select with 'Update Select with multi-select Listbox'.

You will also want to update the List Box Q input to come from the File Browse tool instead of the Input tool, so that the values will update instantly

[mcdevittp]

Thank you so much, that's the solution i was looking for!!!