Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

  • This transform might be automatically applied as one of the first steps of your recipe. See Initial Parsing Steps.
  • If you want to hide a column from view, select Hide from the column drop-down. Note that the data can still be referenced in your transforms and appears in any generated output. See Transformer Page.
  • If you are working with large datasets, you might want to drop delete columns at the beginning of your recipe, which can assist application and job execution performance. Use the tilde operator to drop ranges specify ranges of columns.
  • You can also specify the columns that you wish to retain and then add the Keep action to drop delete all other columns in the dataset.

...

D code

drop col:ThisOldColumn action: Drop

Output:  Drops the Deletes the column named ThisOldColumn.

...

D code

drop col: FirstName, MiddleInitial action: Drop

Output: Drops  Deletes the columns FirstName and MiddleInitial from your dataset.

...

The following transform keeps the listed columns and drops all deletes all others in the dataset:

D code

drop col: FirstName, MiddleInitial action: Keep

...

D code

drop col:Column1~Column20 action: Drop

Output:  Drops the Deletes the columns Column1 and Column20 and all columns displayed in between them in the data grid.

...

TokenRequired?Data TypeDescription
dropYtransformName of the transform
colYstringName of the column or expression for columns to dropdelete
actionYstringDrop or Keep the listed columns

...

Identifies whether the action performed by the transformtransformation:

  • Drop - Listed columns are dropped from deleted from the dataset.
  • Keep - Listed columns are retained in the dataset, and all other columns are droppeddeleted.

D s
snippetusage

Required?Data Type
YesString (Drop or Keep)

...