Extract a Subtable

Extracts a table from an existing table.

Overview

This procedure helps you create a new table from an existing one by choosing which columns and rows to keep or remove. You can include or exclude specific columns and filter rows using selection formulas.

Input Concepts

Concept
Type
Description
Default
Required

table

table

The original table from which the new table will be extracted.

No default

Yes

included columns

list of strings

Columns to include in the new table.

All

No

excluded columns

list of strings

Columns to exclude from the new table.

None

No

included row selection formula

string

Formula to select rows to include.

-

No

excluded row selection formula

string

Formula to select rows to exclude.

-

No

Output Concepts

Concept
Description

table

The extracted table

Examples

For the example below, consider the following table:

Name
Color
Taste

Apple

Red

Sweet

Banana

Yellow

Sweet

Lemon

Yellow

Sour

extract a subtable from the table where
    the included columns are "Name", "Color"

Last updated

Was this helpful?