1.1 - 8.10 - LevenshteinDistance Syntax Elements - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)
TargetColumn
Specify the name of the input column that contains the target text.
SourceColumns
Specify the names of the input columns that contain the source text.
LevenshteinThreshold
[Optional] Specify whether to return the Levenshtein distance for a source-target pair. The threshold must a positive integer. The function returns the Levenshtein distance for a pair if it is less than or equal to threshold; otherwise, the function returns -1.
Default behavior: The function returns the Levenshtein distance of every pair.
OutputDistanceColName
[Optional] Specify the name of the output column that contains the Levenshtein distance for a source-target pair.
Default: 'distance'
OutputTargetColName
[Optional] Specify the name of the output column that contains the compared target text.
Default: 'target'
OutputSourceColName
[Optional] Specify the name of the output column that contains the compared source text.
Default: 'source'
Accumulate
[Optional] Specify the names of the input columns to copy to the output table.