This is the multi-page printable view of this section. Click here to print.

Return to the regular view of this page.

Search

Operators in the Search category

1: Dictionary matcher
2: Keyword Search
3: Regular Expression
4: Substring Search

Home > Search

Operators

Operator	Description
Dictionary matcher	Matches tuples if they appear in a given dictionary
Keyword Search	Search for keyword(s) in a string column
Regular Expression	Search a regular expression in a string column
Substring Search	Search for Substring(s) in a string column

Total: 4 operators

1 - Dictionary matcher

Matches tuples if they appear in a given dictionary

Input Properties

Property	Requirement	Type	Default	Description
Dictionary	✓	String	-	Dictionary values separated by a comma
Attribute	✓	String	-	Column name to match
Result Attribute	✓	String	matched	Column name of the matching result
Matching Type	✓	Scan, Substring, Conjunction	-

Output Ports

Port	Mode
0	Set Snapshot

2 - Keyword Search

Search for keyword(s) in a string column

Input Properties

Property	Requirement	Type	Default	Description
attribute	✓	String	-	Column to search keyword on
keywords	✓	String	-	Keywords

Output Ports

Port	Mode
0	Set Snapshot

3 - Regular Expression

Search a regular expression in a string column

Input Properties

Property	Requirement	Type	Default	Description
Case Insensitive		Boolean	false	Regex match is case sensitive
Attribute	✓	String	-	Column to search regex on
Regex	✓	String	-	Regular expression

Output Ports

Port	Mode
0	Set Snapshot

4 - Substring Search

Search for Substring(s) in a string column

Input Properties

Property	Requirement	Type	Default	Description
attribute	✓	String	-	Column to search substring on
Substring	✓	String	-	Substring
Case Sensitive	✓	Boolean	false	Whether the substring match is case sensitive

Output Ports

Port	Mode
0	Set Snapshot