Counts the number of instances of a specified pattern in a column and writes that value into a newly generated column. Source column is unchanged.
|countpattern col: myCol on: 'honda'|
Output: Generates a new column containing the number of instances of the string
honda that appear in each row of the column,
countpattern col:column_ref [ignoreCase:true|false] [after:start_point | from: start_point] [before:end_point | to:end_point] [on:'exact_match']
|countpattern||Y||transform||Name of the transform|
|col||Y||string||Source column name|
true, matching is case-insensitive.
countpattern col: MyCol after: 'Importantentry:'
Output: Counts Counts
1 if if there is a value that appears anything that appears in the
MyCol column value after the string
Important: of value in
MyCol . If the
after value does string
entry:. If the value
entry: does not appear in the column, the output value is is