The Select Tool is used to select, rename and reorder columns, modify data types, and add column descriptions. This blog will outline some of the functions possible with the tool!
- Simple Select Tool
Select the fields from the inputted data that you want to see in the output. This is useful for getting rid of unwanted or unnecessary columns.
2. Modify Data Types
Change the data types of fields. Very useful for incorrectly stored data such as dates being stored as strings.
3. Rename, Reorder, and Describe
Used to change the order and names of columns. Can also add a description for each field which is helpful for handover.
4. Sort by Column Name
Reorder fields by alphabetically order for example.
5. Field Name Prefix
Add a prefix to column names.
The Select Tool is a vital weapon in the data preparation arsenal. When used early to remove unwanted fields and correct data types, your Alteryx workflows not only run quicker but the resulting outputs are properly formatted!