Table Drop Columns
Description
Section titled “Description”The Table: Drop Columns step writes a copy of the source table to the output table, leaving out the columns you choose. Every other column keeps its name, type, and position.
Source & Options
Section titled “Source & Options”- Source Table and Output Table — the table to read and the table to write.
- Columns to drop — the columns to leave out. Choose at least one. A column the source doesn’t have is ignored, so the step still runs when an earlier step stops producing it.
- Numeric order prefix (optional) — put the kept columns that start with this text in numeric order, in the positions they occupy. With the prefix
Tags_,Tags_2comes beforeTags_10instead of after it. - Table of Column Names (
drop_from) and Column Holding the Names (drop_from_column, defaultdrop), in the Columns Named by a Table section (optional) — a table whose cells in that column, each a JSON list of column names, name more columns to leave out. The table is read when the step runs.
Related
Section titled “Related”- Table Extract — select, rename, and compute columns
- Table Promote Header