Skip to main content
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
required
A human-readable name for the component.
​
Target Grid Variable
drop-down
required
Select a grid variable to remove data from. Read Grid Variables to learn more.
​
Operation
drop-down
required
  • 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
required
Select the columns from the target grid variable that will be used to match, marking data to be removed.To use grid variables, select the Use Grid Variable checkbox at the bottom of the dialog. For more information, read Grid variables.
​
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.