Update a Column

Updates a column in a table.

Overview

This procedure updates a column in a table.

Input Concepts

Concept
Type
Description
Default
Required

table

Table

The table that contains the column to be updated

No default

Yes

the column name

Text

The name of the column to be updated.

No default

Yes

the column values

List

The values to update the column with

No default

Either the column values or the column formula must be provided for this procedure. If the row numbers are specified, then the column values is also required.

the column formula

Text

A formula applied to the column

No default

Either the column values or the column formula must be provided for this procedure.

the row numbers

List

The row numbers that apply to the column update

No default

No

the other table

Table

Another table to reference

No default

No

Output Concepts

Concept
Description

table

The table with the column updated.

Examples

In the examples below, 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

1. Updating a Column by Specifying the Column Values

update the column in the table where
    the column name is "City"
    the column values are "Mountain View", "Cupertino", "Fremont"

2. Updating a Column by Specifying the Column Values and Row Numbers

update the column in the table where
  the column name is "City"
  the row numbers are 1,2
  the column values are "Dallas"

In this example, multiple rows (1 & 2) are updated with the same value (Dallas).

Last updated

Was this helpful?