Data types

The data type is a description of the type of information contained in an attribute or column. The available data types are:

• String – contains data in a string format, such as a name Robert Paulson or a serial number SN/395385A345. This field can contain a maximum of 255 characters.

• Date – contains data formatted as a date. Because there are multiple date formats available, make sure to use the date format dropdown to select the date format of the source information.

• Integer – contains a whole integer number, such as 21 or 119548.

• Big Int – contains a very long whole integer number, such as 8454547333056.

• Decimal – contains a number including a decimal (sometimes known as Float), such as 4863.006.

• Boolean – contains a yes or no value, expressed as a digital 1 or 0. Accepted values for true: t, y, 1, yes, and true. Accepted values for false: f, n, 0, no, and false.