LevenshteinDistance Syntax Elements - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.10
1.1
Published
October 2019
Language
English (United States)
Last Update
2019-12-31
dita:mapPath
ima1540829771750.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢
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.