Remove From Grid
    • Dark
      Light

    Remove From Grid

    • Dark
      Light

    Article Summary

    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

    PropertySettingDescription
    NameStringA human-readable name for the component.
    Target Grid VariableSelectSelect a Matillion ETL grid variable to remove data from. Read Grid Variables to learn more.
    Fixed/GridSelectSelect whether to match elements of the target grid variable to those in a fixed list or a source grid variable.
    OperationSelectIn: 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 ColumnsColumn SelectorSelect the columns from the target grid variable that will be used to match, marking data to be removed.
    Values GridMultiple Data TypesEnter 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 VariableSelectSelect 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 MappingMultiple SelectUse 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.