Text Input creates different data types depending on whether your workflow uses Alteryx Multi-threaded Processing (AMP) or the original engine. AMP: Text Input creates a V_String data type of maximum length (up to 2,147,483,647 characters).

May 17, 2021 · When I try using Select or even Formula (toNumber) to convert the type to a double or Int, it then gives me either a null or 0 instead of the number itself. I need to summarize the sum of these unioned data sets, so leaving it as a String won't work. Any ideas on how to fix?

Alteryx supports string, numeric, date-time, and boolean data types, as well as, spatial objects. You can use the Select tool, or any tool that includes select functionality, to modify the type of data in a column.

Jun 14, 2023 · "Use Auto Field to read through all of the records of an input and set the field type to the smallest possible size relative to the data contained within the column. The tool correctly assigns a numeric field to a string data type where any record starts with zero and not a number."

When bringing data into Alteryx a lot of users often add a select tool to check the data type and structure. Data types are very important because of the available operations/functions in tools can be adjusted to fit the data type being used!

First, select text input from the In/Out tab in Alteryx: Then, in the configuration pane to the left, you will see the starting of a table. In here, you can begin to create a small data set. Double click on cells to enter data values. The tool autoconfigures data types based on the values you enter.

Dec 6, 2024 · Yes - you can input text (.txt) files! The approach described below applies to all delimited text files - and can also input other file types (like XML) as plain text. Simply point your Input Data Tool to a file of your choice and specify the configuration options below:

Mar 20, 2024 · To change data types, you can either manually update them with a Select Tool, auto-detect them with an Auto-Field Tool, or temporarily change them with formulas. The data type needed is typically determined by the operation you are trying to apply to it.

Feb 26, 2025 · There's no way to change it before reading, but the common work around for this is to leverage a batch macro. There's lots of threads on this topic, but the key thing is to make sure to configure it by name/position, not the schema (or else you'll have the same issue):

Learn how to convert data types in Alteryx with the Auto-field, Select and DateTime Parse tools