nPath

The nPath function matches specified patterns in a sequence of rows from one or more input tables and extracts information from the matched rows.

Options

Filter (strings seperated by new line)

Specifies filters to impose on the matched rows. The function combines the filter expressions using the AND operator. %%00010The filter_expression syntax is: %%00010symbol_expression comparison_operator symbol_expression %%00010The two symbol expressions must be type-compatible. The symbol_expression syntax is: %%00010{ FIRST | LAST }(column_with_expression OF [ANY](symbol[,...])) %%00010The column_with_expression cannot contain the operator AND or OR, and all its columns must come from the same input. If the function has multiple inputs, then column_with_expression and symbol must come from the same input. %%00010The comparison_operator is either <, >, <=, >=, =, or <>. %%00010This argument can improve or degrade nPath performance, depending on several factors. For details, refer to 'Filters'

Mode

Specifies the pattern-matching mode: %%00010 OVERLAPPING: The function finds every occurrence of the pattern in the partition, regardless of whether it is part of a previously found match. Therefore, one row can match multiple symbols in a given matched pattern. %%00010 NONOVERLAPPING: The function begins the next pattern search at the row that follows the last pattern match. This is the default behavior of many commonly used pattern matching utilities, including the UNIX grep utility.

Pattern

Specifies the pattern for which the function searches. You compose pattern with the symbols that you define in the Symbols argument, operators, and parentheses. Table describes the simplest patterns, which you can combine to form more complex patterns. When patterns have multiple operators, the function applies them in order of precedence, and applies operators of equal precedence from left to right. Table also shows operator precedence. To force the function to evaluate a subpattern first, enclose it in parentheses. To specify that a subpattern must appear a specific number of times, use the 'Range-Matching Feature' %%00010 For pattern matching details, refer to 'Pattern Matching'.

Result (strings seperated by new line)

Defines the output columns. The col_expr is an expression whose value is a column name; it specifies the values to retrieve from the matched rows. The function applies aggregate_function to these values. For details, see 'Result: Applying Aggregate Functions'. %%00010The function evaluates this argument once for every matched pattern in the partition (that is, it outputs one row for each pattern match).

Output Schema

Output Schema, if Volatile is true then use user login as the schema.

Output Table

Output Table

VAL Location

VAL Location

Symbols (strings seperated by new line)

Defines the symbols that appear in the values of the Pattern and Result arguments. The col_expr is an expression whose value is a column name, symbol is any valid identifier, and symbol_predicate is a SQL predicate (often a column name).%%00010 For example, the Symbols argument for analyzing website visits might look like this: %%00010 Symbols %%00010 (%%00010 pagetype = 'homepage' AS H, %%00010 pagetype <> 'homepage' AND pagetype <> 'checkout' AS PP, %%00010 pagetype = 'checkout' AS CO %%00010)%%00010 The symbol is case-insensitive; however, a symbol of one or two uppercase letters is easy to identify in patterns. If col_expr represents a column that appears in multiple input tables, then you must qualify the ambiguous column name with its table name. For example: Symbols ( weblog.pagetype = 'homepage' AS H, weblog.pagetype = 'thankyou' AS T, ads.adname = 'xmaspromo' AS X, ads.adname = 'realtorpromo' AS R ) For more information about symbols that appear in the Pattern argument value, refer to 'Symbols'. For more information about symbols that appear in the Result argument value, refer to 'Result: Applying Aggregate Functions'.

Volatile

Specifies whether the table should be a VOLATILE table. If true, then the table is automatically deleted, otherwise it is users responsibility to remove or clean it up for space.

Nodes

• String Configuration7 ×
• Python Script2 ×
• Boolean Configuration1 ×
• Component Input1 ×
• Component Output1 ×
• Show all 12 nodes

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Database
• FeatureKNIME Quick Forms

Links

• No links available