LogoLogo
About
Tables: v2
  • Home
  • Guides
  • BDK
  • REST API
  • Release Notes
Tables: v2
  • Getting Started
    • Tables Overview
  • Table Creation
    • Create a Table
    • Create a Sample Table
    • Create a Pivot Table
    • Create an Integer Table
    • Create a Table from JSON
    • Create a Table from the Rows
    • Create a Combined Table
    • Create a Merged Table
    • Get a Table from a File
  • Rows
    • Get Row(s)
    • Get Row Count
    • Get Row Number
    • Get Value from Row
    • Group Rows
    • Insert a Row
    • Insert an Empty Row
    • Remove Duplicate Rows
    • Set a Row to JSON
  • Columns
    • Get a Column
    • Get a Column's Values
    • Get a Column Number
    • Get Column Count
    • Get Column Stats
    • Get Column Names
    • Change a Column's Data Type
    • Delete Columns
    • Insert a Column
    • Move a Column
    • Rename a Column
    • Rename Columns
    • Round a Column's Values
    • Update a Column
  • Cells
    • Set a Cell in a Table
  • Conversions
    • Convert CSV to a Table
    • Convert a Table to CSV
    • Convert a Table to Excel
  • Manipulations
    • Clear a Table
    • Combine Tables
    • Copy a Table
    • Extract a Subtable
    • Group a Table
    • Query a Table
    • Sort a Table
    • Split a Table
    • Join Subtables
    • Replace a Value
    • Replace a Value in a Column
    • Transpose a Table
Powered by GitBook
On this page
  • Overview
  • Input Concepts
  • Output Concepts
  • Examples

Was this helpful?

Export as PDF
  1. Manipulations

Replace a Value in a Column

Replaces occurrences of a value in a table.

Overview

This procedure finds and replaces all instances of a value within a specific table column. It helps keep your data clean and consistent by automatically replacing all matching values in the selected column.

Input Concepts

Concept
Type
Description
Default
Required

table

table

The table to perform the replacement in.

No default

Yes

column

text

The name of the column to perform replacement in.

No default

Yes

value

text/number/date

The value to be replaced.

No default

Yes

replacement

text/number/date

The value to replace with.

No default

Yes

Output Concepts

Concept
Description

table

The updated table.

Examples

1. Replace Values in a Specific Column of a Sample Table

create a sample table
replace "San Jose" in the table's "City" column where
    the replacement is "Charlotte"
Name
Number
Address
City

john

+ 1 (415) 691 9426

123 east street

San Francisco

joe

+ 1 (415) 691 1234

321 west street

Charlotte

jack

+ 1 (415) 691 4595

213 north street

San Francisco

2. Replace Values in a Specific Column of a Sample Integer Table

create an integer table
replace 300 in the table's "Max" column where
    the replacement is 150
Amt
Min
Max

100

10

150

200

5

500

Last updated 1 month ago

Was this helpful?