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 (415) 691 9426

123 east street

San Francisco

joe

+ 1 (415) 691 1234

321 west street

San Jose

jack

+ 1 (415) 691 4595

213 north street

San Francisco

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

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

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)"}

Last updated

Was this helpful?