AddColumns.pdf

From Array Suite Wiki

Jump to: navigation, search


Contents

Add Columns

Overview

The Add Columns Table menu item allows users to add columns in four different ways:

  • New empty columns,
  • Column transformation,
  • Column summarization,
  • Column calculation.

All four methods are covered here. It can be accessed by going to: Table | Columns | Add Columns.

Table AddColumns Menu.png

[back to top]

Input Data Requirements

This works on Table objects, including Design Tables and Annotation tables.

Step 1: Select source table

The user will first be asked to choose the table to which columns should be added:

SelectData0.png

[back to top]

Step 2: Choose Column Source

The user is then presented with the "Choose Column Source" window, during which user can decide in which way the new column will be added:

AddColumns0.png

[back to top]

Option 1: Add new columns

For adding new columns, the user can choose the number of columns to add, a column prefix (which will be the column name if only adding one column, or enumerated if adding multiple columns), the Column type (Factor, Numeric, Integer, Logical, and Character), and where to add the column in the table.

AddColumns1.png

[back to top]


Option 2: Add column by transformation

The user can generate a new column by performing a transformation on the selected numeric column in the table:

AddColumns2.png

Options

  • Adding a constant: Add the specified value to each element
  • Multiplying by a constant: Multiply the specified value to each element
  • Censor if value < a specified value: Set the cell to this value if the source cell is less than the specified value
  • Censor if value is > than a specified value: Set the cell to this value if the source cell is greater than the specified value
  • The user can also perform an arithmetic operation using another column (Divide, Divided by, Multiply, 'Add, Subtract, and Subtracted by)
  • Transformation method: A transformation method can be specified for the output. Available options are described in the [ Transformation Table].
[back to top]


Option 3: Add column by summarization

For column summarization, the user can choose a number of Summarization Methods that can be performed on any numeric columns as listed below:

AddColumns3.png

[back to top]

Option 4: Add column by calculation

For column calculation, the user can build an arithmetic expression by choosing a column on the left, clicking "Insert Column" button, then select the calculation method from the Method window, click "Insert Method". The user can then continue to add calculations and columns to build the full expression.

AddColumns4.png

[back to top]


Output Results

A new column will be added to the original table, as a new column, or from transformation, summarization, or calculation.

Example Output

Given the following table:

Table AddColumns StartTable.png

Adding columns by the four methods can result in additional columns like this:

Table AddColumns FinalTable.png

[back to top]

Related Articles

[back to top]

EnvelopeLarge2.png