...
The following transform keeps the listed columns and drops all others in the dataset:
| D code |
|---|
drop col: FirstName, MiddleInitial action: Keep |
Output: Dataset only contains FirstName and MiddleInitial columns.
...
Output: Drops the columns Column1 and Column20 and all columns displayed in between them in the data grid.
| D s | ||
|---|---|---|
|
| D code |
|---|
drop col:column_ref action: [Drop|Keep] |
| Token | Required? | Data Type | Description |
|---|---|---|---|
| drop | Y | transform | Name of the transform |
| col | Y | string | Name of the column or expression for columns to drop |
| action | Y | string | Drop or Keep the listed columns |
...
