In today’s post and video I’m going to share a quick way to rapidly populate the select tool in Alteryx if you need to change the data type or rename a bunch of fields in your data stream.  While Alteryx’s visual interface does result in extremely simple and intuitive workflows, one downside for hard-core developers is the loss in productivity experienced by using a GUI vs. generating code directly.  Fortunately there are some workarounds…

Imagine that you have a dataset with over 100 generic column names.  You already know the final set of column names that you’d like to use, the question is how can you quickly overlay the new names over the old column names in you data.  Below is a screenshot showing the normal manual method for renaming each field or change the data type using the select tool.

Of course that’s all well and good, except you don’t want to have to manually type all the new names in.  If you want to do a bulk change, then you can use the Save Field Configuration option.

Continue reading “Automate Populating Select Lists in Alteryx” →