Column Elements Overview 


Column elements in an information link may refer to multiple tables in different databases. However, with Information Designer, columns are represented as if they were located in the same spreadsheet, regardless of the physical location of the data.

In a TIBCO Spotfire context, columns are entities that can be assigned to the axes of a visualization. For example, data from a fruit company may include fruit type, sales and cost:

id_column_table.png

All information in a relational database is represented explicitly as values in tables, composed of rows (records) and columns (fields).

Column elements created in Information Designer can be based on several database columns. For example, a column element can be calculated as the sum of the values in two different columns. The underlying columns can reside in the same database table, in different tables, or even on different databases.

Columns can be defined with built-in column filters that are automatically applied when the column is retrieved. You can also add a personalized or a parameterized column filter condition that limits data depending on the currently logged in user, see Personalized Information Links and Parameterized Information Links. Columns can also be set up to include aggregated data.

In the Information Designer, columns are represented by these icons:

id_real_i.png

Real, SingleReal or Currency column

id_integer_i.png

Integer or LongInteger column

id_string_i.png

String column

id_boolean_i.png

Boolean column

id_date_i.png

Date column

id_datetime_i.png

DateTime column

id_time_i.png

Time column

id_blob_i.png

BLOB (binary large object) column

id_clob_i.png

CLOB (character large object) column

id_unknown_i.png

Unknown column (in the Data Sources tree only).
Must be set manually to one of the accepted column types (above) before it can be saved as a column element.

See also:

Creating a Column Element

Editing a Column

Deleting a Column

Data Types