...
| Token | Required? | Data Type | Description | ||||||
|---|---|---|---|---|---|---|---|---|---|
| filter | Y | transform | Name of the transform | ||||||
| type | Y | string | String value representing the type of filtering to perform. | ||||||
| row | N | string | Expression identifying the row or rows to filter. If expression evaluates to true for a row, the row is either kept or deleted. | ||||||
| col | N | string | Name of the column or expression for columns to delete | ||||||
| missing | N | string | Name of column to evaluate for missing values. | ||||||
| mismatched | N | string | String literal for the data type to check for mismatches. | ||||||
| exactly | N | string | String literal,
| ||||||
| oneOf | N | string | List of string literals, any of which can be matched. | ||||||
| lessThan or lessThanEqual | N | integer, decimal, or expression | Integer or decimal literal or expression evaluating to numeric value below which results in a match. Can also match on the specified expression exactly. Parameter is also used for the Between condition type. | ||||||
| greaterThan or greaterThanEqual | N | integer, decimal, or expression | Integer or decimal literal or expression evaluating to numeric value above which results in a match. Can also match on the specified expression exactly. Parameter is also used for the Between condition type. | ||||||
| contains | N | string | String literal, | ||||||
| startsWith | N | string | String literal,
| ||||||
| endsWith | N | string | String literal, | ||||||
| action | Y | string | Drop or Keep the listed columns |
...
For the Exactly condition type, this value is a String literal,
itemd-s-
, or regular expression that exactly matches row values in the specified column.lang item pattern
...
| Required? | Data Type | ||||
|---|---|---|---|---|---|
| Required for One Of condition type only | List of string literals,
|
...
For the Contains condition type, this value identifies a String literal,
itemd-s-
, or regular expression, which is used to evaluate partial or full matches to row values in the specified column.lang item pattern
...
| Required? | Data Type | ||||
|---|---|---|---|---|---|
| Required for Contains condition type only | String literal,
|
...
For the Starts With condition type, this value identifies the String literal,
| d-s-itemlang | ||
|---|---|---|
|
...
| Required? | Data Type | |||||
|---|---|---|---|---|---|---|
| Required for Starts with condition type only | String literal, |
endsWith
For the Ends With condition type, this value identifies the String literal,
| d-s-itemlang | ||
|---|---|---|
|
...
| Required? | Data Type | |||||
|---|---|---|---|---|---|---|
| Required for Ends with condition type only | String literal, |
action
...
