Fields Table

The Fields Table is the section in the Data Model Designer where you define, configure, and manage the columns of your data model. From here, you can add fields from source tables or views, create calculated columns, set column properties, and control how data is displayed and behaves in worksheets or other views.

In this section:

Topic	Description
Add fields	Add fields from tables or views in the Design Graph to the Fields Table for use in the data model.
Add a calculated column	Create a column whose values are calculated using SQL expressions or formulas based on other fields.
Set column properties	Configure how each column is displayed, formatted, and behaves, including general, edit, and advanced settings.
Display images	Show images in worksheets by setting a column’s format to Image (Raw or URL).
Add hyperlinks	Add clickable hyperlinks to columns, either from existing database fields or custom calculated columns.
Window function	Apply window function calculations such as SUM, RANK, or LAG across partitions of your dataset.
Oragnize columns	Change the order of columns and adjust their width using toolbar actions.
Delete a column	Remove a column from the Fields Table using the Design Graph or directly from the table view.