Alteryx Select

The Alteryx Select tool is useful to select or detect the columns, and we can rename the column’s names. You can also use this Alteryx select tool to change the required column data type and size.

Drag the Input Data Tool, and select the Customers_text text file from the configuration tab. From the below image, you can see that the file has fifteen records.

Alteryx Select Tool - Datatype Conversion 1

If you look at the text file metadata, all the columns are of the string data type.

Alteryx Select Tool - Datatype Conversion 2

Alteryx Select Tool Example

Drag and drop the Select tool to the canvass and connect the Input tool to it.

Alteryx Datatype Conversion 3

Within the Alteryx Select tool Configuration tab, you can see the source column names, data type, column size, empty field to rename the column and provide the description.

Alteryx Datatype Conversion 4

By clicking the down arrow beside the column type shows you the list of available data types. Please change the data type of a Alteryx column as per your requirement.

Alteryx Select Tool - Datatype Conversion 5

Here, we changed the yearly income, sales columns to double and EmpID to a 32-bit integer. Then we renamed the Yearly Income as Income and Occupation column as Profession.

Alteryx Select Tool - Datatype Conversion 6

Hit the Run button to see the Alteryx select tool result.

Alteryx Select Tool - Datatype Conversion 7

Let me load this output into SQL Server new table AlteryxSelectTool. We have already explained the steps in Load Alteryx Text File into SQL Server article.

Alteryx Select Tool - Datatype Conversion 8

The below image shows you the Alteryx SQL configuration settings.

Alteryx Select Tool - Datatype Conversion 9

Run the Select tool workflow.

Alteryx Select Tool - Datatype Conversion 10

Within the Management Studio, you can see the AlteryxSelectTool table result.

Alteryx Select Tool - Datatype Conversion 11

For the column datatype, you can look at the table definition.

Alteryx Select Datatype Conversion 12