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

Automation

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

Results

Name	Color
Apple	Red
Banana	Yellow
Lemon	Yellow