Use the Input Data tool to bring data into your workflow by connecting to a file or database.
- Click the Input Data tool in the tool palette and drag it to the workflow canvas area.
- In the Configuration window, click the Connect a File or Database drop-down arrow.
- The Text Input tool in Alteryx is a fundamental tool that allows you to manually enter text to create small data files for input within your workflows.
String Data
- Represents alphanumeric data, including letters, numbers, spaces, and other characters.
- V/String: Variable-length string, dynamically adjusts to the length of the string. Supports Latin-1 characters.
- V/W/String: Variable-length wide string, supports Unicode and international characters.
Numeric Data
- Represents numerical values.
- Byte: Positive whole numbers from 0 to 255.
- Int16: Integers from -32,768 to 32,767.
- Int32: Integers from -2,147,483,648 to 2,147,483,647.
- Int64: Integers from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807.
- Fixed Decimal: Numbers with a fixed number of decimal places, often used for currency.
- Float: Single-precision floating-point numbers.
- Double: Double-precision floating-point numbers, offering higher precision.
Date/Time Data
- Represents dates and times.
- Date and Time: Stores both date and time information.
- Alteryx can handle various date/time formats, but it's often best to standardize them for consistency etc.
