FLAG_COLUMN_FROM_PATTERN
Creates a new column, based on the presence of a user-specified pattern in an existing column.
Parameters
-
sourceColumn
– The name of an existing column. -
targetColumn
– The name of a new column to be created. -
flagType
– A value that must be set toPattern
. -
pattern
– A regular expression, indicating the pattern to be evaluated. -
trueString
– A value for the new column, if a null value is found in the source. If no value is specified, the default isTrue
. -
falseString
– A value for the new column, if a non-null value is found in the source. If no value is specified, the default isFalse
.
Example
{
"RecipeAction": {
"Operation": "FLAG_COLUMN_FROM_PATTERN",
"Parameters": {
"falseString": "No",
"flagType": "Pattern",
"pattern": "N.*",
"sourceColumn": "wind_direction",
"targetColumn": "northerly",
"trueString": "yes"
}
}
}