Creating a constant column

Constant columns take a single value for all rows. They can be useful as input into computed columns or as an identifier in stacked tables. To create a constant column:

  1. Choose Table > New Constant Column...
  2. Enter a value and press OK

If the entered value can be parsed as a date, the constant column will be a date column. If the entered value can be parsed as a number, a numeric column will be created. Otherwise, the entered value will be interpreted as text.

By default, the constant column's name reflects the constant value, but you can give it a new name of your choosing. (Note that changing the name will not affect the value itself.)

See also: