Insert a Column

Inserts a column into a table.

Overview

This procedure inserts a column into a table.

Input Concepts

Concept	Type	Description	Default	Required
table	Table	The table to insert the column into	No default	Yes
column name	Text	The name of the column to insert	No default	Yes
column number	Number	The position of the column to be inserted.	Defaults to the end of the table, if no column number is specified.	No
column values	List	The values to populate the column	No default	Either column values or a column formula need to be specified.
column formula	Text	A formula applied to the column	No default	Either column values or a column formula need to be specified.
default value	Text	A default value for the column	No default	No
other table	Table	Another table to reference	No default	No

Output Concepts

Concept	Description
table	The table with the column inserted.

Examples

1. Inserting a Column by Specifying the Column Values

For this example, the table refers to the following table, which can be generated using the create a sample table procedure:

Name	Number	Address	City
john	+ 1 [phone]	123 east street	San Francisco
joe	+ 1 [phone]	321 west street	San Jose
jack	+ 1 [phone]	213 north street	San Francisco

Automation

insert a column in the table where
  the column name is "Age"
  the column values are 30, 25, 35

Results

2. Inserting a Column by Specifying the Column Formula

For this example, the table refers to the following table, which can be generated using the create an integer table procedure:

Amt	Min	Max
100	10	30
200	5	500

Automation

insert a column in the table where
  the column name is "Test Col"
  the column formula is @{"type": "column_formula", "value": "conditional_column_copy(.05, Min <= 10)"}

Results