Contents x
Remove From Grid
  • Dark
    Light
Contents

Remove From Grid

  • Dark
    Light

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 either kept or discarded.

Properties

Property Setting Description
Name String A human-readable name for the component.
Target Grid Variable Select Select a Matillion ETL grid variable to remove data from. Read Grid Variables to learn more.
Fixed/Grid Select Select whether to match elements of the target grid variable to those in a fixed list or a source grid variable.
Operation Select 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 Column Selector Select the columns from the target grid variable that will be used to match, marking data to be removed.
Values Grid Multiple Data Types 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 Select 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 Multiple Select 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.
What's Next

Cookie consent

We use our own and third-party cookies to understand how you interact with our knowledge base. This helps us show you more relevant content based on your browsing and navigation history.