Remove from Grid

This component will take in grid variable data and remove data based on the user's definition. You can use this component to remove rows from grid columns but not the columns themselves. To establish which data is to be removed, the target grid variable can be matched to a fixed list or a source grid variable, and the user-defined key columns will either be kept or discarded.

Properties

Name = string

A human-readable name for the component.

Target Grid Variable = drop-down

Select a grid variable to remove data from. Read Grid Variables to learn more.

Operation = drop-down

In: Remove all data except the data specified from the target grid variable.
Not In: Remove only the data specified from the target grid variable.

Key Columns = dual listbox

Select the columns from the target grid variable that will be used to match, marking data to be removed.

To use grid variables, tick the Use Grid Variable checkbox at the bottom of the Key Columns dialog.

Values Grid = column editor

Enter data into each key column that will match data to data stored in the target grid variable. Depending on the Operation (In or Not In), matching rows will be either removed or kept.

Snowflake	Databricks	Amazon Redshift
✅	✅	✅