Count Occurrences
Description
This activity counts the number of times a pattern appears in the column values. The pattern matching is based on a given mode
- Substring
- Complete value
- Regular expression
It also considers the casing type - Case sensitive
- Case insensitive
Input
Data Only
Output
Transformed Data
Configuration Fields
- ColumnNames The name(s) of the column(s) to be processed.
- Pattern The pattern to search for, which can be a string or regular expression.
- MatchingMode Defines the match mode (e.g., Substring, Complete value, or Regular expression).
- MatchCase Specifies whether the match should be case-sensitive or case-insensitive.
Sample Input
| product_id | product_name |
|---|---|
| B07JW9H4J1 | Boat Bluetooth Speaker |
| B07AB2CD34 | Boat Wired Headphones |
| B07XY1MN67 | Sony Wireless Headphones |
| B07EF3PL88 | Boat Rockerz Bluetooth Earphones |
| B08GZZ8FQT | Boat Audio System |
Sample Configuration
Sample Output
| Pattern_Count |
|---|
| 4 |