Field Data Types
Contents
Overview
A table field has one of the following types:
- text
- datetime
- decimal
- integer
- reference
- choice
- duration
Having the correct type is crucial for many capabilities of Explore Analytics. This is described in greater details in the sections below.
Reviewing and Changing Types
The field type is automatically determined and in most cases requires no adjustment.
Uploading or Import Data
When you upload a data file or import a Google spreadsheet, the data is reviewed and automatically classified into text, datetime, decimal, or integer. The automatic classification is often very accurate, but not always. It is advisable to select the option to "Review and make changes".
The second step in the review shows you the fields and the detected type and allow you to make certain changes.
Reviewing and Changing Field Type After the Table is Defined
Whether the table is in an external data source (database or application) or in the "explore" data source (uploaded or imported), you can review the fields and make changes.
To review the fields, see Listing Table Fields. You'll see a list of fields as shown below.
To make a change, click on a field (e.g., COMMISSION_PCT in the picture above) and select "Edit this field" from the context menu.
In this dialog, you can change the type of the field.
