Column types

Data tables support columns of the following data types:

• Short text

• A single-line text field. Supports a maximum of 756 characters.

• Long text

• A multi-line text area. Supports a maximum of 10,000 (ten thousand) characters.

• Integer

• A whole number, such as 22 or 150.

• Decimal

• A number in decimal format, such as 22.7 or 251.73.

• Boolean

• A true or false value.

• Date

• Values in Date format (day/month/year). For example, 13/11/2024.

• DateTime

• Values in DateTime format (day/month/year) and (hours/minutes/seconds), for example: 13/11/2024 and 10:47:23.

• File

• Upload or download files to or from your data tables. The maximum file size is 100 MB.

• Multi-value

• A column that supports storing multiple values in a single cell. Multi-value columns do not support nulls, empty strings, or duplicate values. Sorting columns is not supported. Each table can have a maximum of 20 multi-value columns, and each cell within a multi-value column can store up to 20 values.

  • Value type
  • Supported value types include short Text, Integer, Decimal, Date, and DateTime.

• Link to a table

• Select a data table to link to your current table.

  • Linked data table

  • Select a data table to link to your current table.

  • Display data from

  • Choose a column from the data table you selected. Workato displays the data from this column as a drop-down menu. Data tables support linking short text and long text column types.

Available operands

The operands you can use to filter your data table vary based on your selected column's data type:

Short text

The following operands are available:

• Equals
• Is not equal to
• Starts with
• Is null
• Is not null

Long text

The following operands are available:

• Equals
• Is not equal to
• Starts with
• Is null
• Is not null

Integer

The following operands are available:

• Equals
• Is not equal to
• Is less than
• Is greater than
• Is less or equals
• Is greater or equals
• Is null
• Is not null

Decimal

The following operands are available:

• Equals
• Is not equal to
• Is less than
• Is greater than
• Is less or equals
• Is greater or equals
• Is null
• Is not null

Boolean

The following operands are available:

• Is true
• Is false
• Is null
• Is not null

Date

The following operands are available:

• Equals
• Is not equal to
• Is before
• Is after
• Is on or before
• Is on or after
• Is null
• Is not null

DateTime

The following operands are available:

• Equals
• Is not equal to
• Is before
• Is after
• Is on or before
• Is on or after
• Is null
• Is not null

Link to a table

The following operands are available:

• Equals
• Is not equal to
• In
• Is null
• Is not null

File

The following operands are available:

• Equals
• Is not equal to
• Is null
• Is not null

Multi-value

The following operands are available:

• Contains
• Is not null
• Is null