Skip to content

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 Matillion ETL grid variable to remove data from. Read Grid Variables to learn more.

Fixed/Grid = drop-down

Select whether to match elements of the target grid variable to those in a fixed list or a source grid variable.

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.

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.

This property is only available when Fixed/Grid is set to Fixed.

Source Grid Variable = drop-down

Select the source grid variable. This grid variable should contain data that will match to the target grid variable. These matches will define which rows in the target grid variable are removed or kept, depending on the operation. This property cannot be set to the same grid variable as the target grid variable.

This property is only available when Fixed/Grid is set to Grid.

Key Column Mapping = column editor

Use the dropdown menus to select source grid variable columns and map them to corresponding key columns from the target grid variable. Matching data between mapped columns will define which rows in the target grid variable are removed or kept, depending on the operation.

This property is only available when Fixed/Grid is set to Grid.

Snowflake Delta Lake on Databricks Amazon Redshift Google BigQuery Azure Synapse Analytics
✅ ✅ ✅ ✅ ✅