This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Great question. The attached macro should expand a given field into binary fields as you ask. Be careful in using it though; if you have a lot of possible values in the "field to expand" it could result in an enormous number of columns. You mentioned only having a hundred possible values, so for that problem this macro should work fine.
Hope that helps!
[EDIT: fixed to have False instead of Null values.]
Unfortunately, i can't use your workflow because i don't have the last version of Alteryx. But i replicate the structure and modify to include your solution in my workflow and it's works! Thanks again for your help.
Glad to hear it worked. Aside: one tip/trick I've seen is that you can open a .yxmd or .yxmc in a text editor, and edit the first line to adjust the workflow/macro version. As long as it isn't using anything specific to the more recent version, that's an easy way to "roll back" the version.