The Single-Field Indexer node creates a searchable index from a selected string column of an input data table. By default, the index is based on the TeraEdit object, which enables efficient approximate string matching using edit distance.
The Index Type configuration allows users to choose between different indexing techniques:

• TeraEdit for single-word edit-distance matching
• TeraAuto for single-word matching. Fast but less fault-tolerant than TeraEdit.

The generated index can be passed to downstream nodes, such as the Approximate Index Matcher, to quickly retrieve similar values within large datasets. By storing the indexed values in a structured format, the node enables fast and scalable similarity lookups, even in the presence of spelling variations, typos, or inconsistent text data.

Options

Select Column to Index

Selects the string column from the input table that will be used to build the index. Only string-convertible columns are available.

Index Type

Specifies the indexing technique used to build the searchable index. Different index types optimize matching for different data characteristics:

• TeraEdit – edit-distance calculations and single-word strings.
• TeraAuto - fast, but less tolerant edit-distance calculations.

Representation of Indexed Strings

Specifies how the matched index values are represented in the output table of Approximate Index Matcher, as transformed or original strings.
By default, indexing applies a built-in mapping to improve the precision of index matching. Users can also apply the Character Mapper node to override this default mapping in the Single Field Indexer.
This option determines whether the matched index values in the results are displayed as their transformed or original representations.
Possible values:

• Original
• Normalized

Views

This node has no views

Workflows

• Email Lookup & Validation (1M Records)KNIME Hub
• Frequency-Aware Anomaly Detection with Single-Field IndexerKNIME Hub
• Index Reader and Writer – Reusing Indexed DataKNIME Hub
• Multi-Field Indexing & Dynamic Matching using Single-Field IndexerKNIME Hub
• Patient Name Variation FinderKNIME Hub
• Show all 8 workflows

Links

• No links available

Developers