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. For example, use text columns for alphanumeric values such as names and descriptions, numerical columns for IDs and amounts.
Tip: Track months or years as integers rather than text. For example, when you record months by their digit (1-12) instead of name (January-December) in an integer column, you can apply calculations to the data.
|Text||Any combination of letters, numbers, or symbols, such as for descriptions and names. 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. Recommended for head count, years, or months.|
|Decimal||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, edit the column's details as necessary, and click Save .