A table's Owner can add new columns to the data, such as to track reference notes or dates. To help clarify a column's intent, you can also manage its name and description as necessary.
Note: To save details your organization routinely tracks about data, such as Version or Data Source, an admin can set up tags for datasets.
A table can include multiple types of columns, based on the data to track.
|Text||Any combination of letters, numbers, or symbols. In a query's Structured Query Language (SQL), this data resolves to
|Integer||A whole number—not a fraction or decimal—that can be positive, negative, or 0.|
|Number||A number that can contain decimal values, such as
|Boolean||A value of either
|Timestamp||A date with a time value. By default, in the ISO 8601 format.|
|Date||A date without a time value. By default, in the ISO 8601 format of
Adding Columns to a Table
Note: To ensure the integrity of connected data, you can't delete any columns added to a table.
- From Wdata Home , open the table.
- Click Add Column .
- To help identify the column and its data, enter its ID, name, and description. To use the same value for the ID and name, select Column Name same as Column ID.
- Select the type of data to contain in the column.
- Click Add Column.
Editing a Column's Name or Description
To update the name or description of a column, open the table, and edit the column's details as necessary.