Correlation Arguments - Teradata Vantage
Teradata® Vantage Machine Learning Engine Analytic Function Reference
Product
Teradata Vantage
Release Number
1.0
8.00
Published
May 2019
Language
English (United States)
Last Update
2019-11-22
dita:mapPath
blj1506016597986.ditamap
dita:ditavalPath
blj1506016597986.ditaval
dita:id
lmf1502735330121
Product Category
Teradata Vantage
Introduction
Analytics at Scale: Full Data Set Analysis
Teradata Machine Learning Engine Functions by Category
Time Series, Path, and Attribution Analysis
Pattern Matching with Teradata NPath
Statistical Analysis
Text Analysis
Cluster Analysis
Naive Bayes
Ensemble Methods
Association Analysis
Graph Analysis
Data Transformation
Usage Notes
Functions with Both ML Engine and Teradata SQL Engine Versions
Comments in Queries
Case in Schema, Table, and Column Names
Function Syntax Descriptions
Column Names
Column Specification Arguments
Identification of Categorical Columns
Regular Expressions in Arguments
Input Column Data Types
DATE Columns
BC/BCE Timestamps
Nondeterministic Results
Error Message Delays
Error Message for Incompatible Data Type
Sparse Tables and Dense Tables
Preinstalled Files That Functions Use
Where Functions Save Output Files
Output Tables
Time Series, Path, and Attribution Analysis
Time Series, Path, and Attribution Analysis
ARIMA Functions
ARIMA
ARIMA Syntax
ARIMA Arguments
ARIMA Input
ARIMA Output
ARIMA Examples
ARIMA Example 1: OrdersTable, PartitionColumns, No Seasonality
ARIMA Example 2: Orders, No PartitionColumns, No Seasonality
ARIMA Example 3: No PartitionColumns, Seasonality
ARIMAPredict
ARIMAPredict Syntax
ARIMAPredict Arguments
ARIMAPredict Input
ARIMAPredict Output
ARIMAPredict Example
Attribution
Multiple-Input Attribution
Attribution Syntax (Multiple Inputs)
Attribution Arguments (Multiple Inputs)
Attribution Input (Multiple Inputs)
Model Specification
Attribution Output (Multiple Inputs)
Attribution Example (Multiple Inputs)
Single-Input Attribution
Attribution Syntax (Single Input)
Attribution Arguments (Single Input)
Attribution Input (Single Input)
Attribution Output (Single Input)
Attribution Examples (Single Input)
Single-Input Attribution Example 1: One Regular Model, Multiple Optional Models
Single-Input Attribution Example 2: Multiple Regular Models, One Optional Model
Single-Input Attribution Example 3: Dynamic Weighted Distribution Models
Single-Input Attribution Example 4: Window Models
Single-Input Attribution Example 5: Single-Window Model
Single-Input Attribution Example 6: Unused Segment Windows
Burst
Burst Syntax
Burst Arguments
Burst Input
Burst Output
Burst Examples
Burst Example 1: TimeInterval, SplitCriteria ('nosplit')
Burst Example 2: TimeTable, SplitCriteria ('proportional')
Burst Example 3: TimeTable, SplitCriteria ('gaussian')
Burst Example 4: Time_Table File
Change-Point Detection Functions
ChangePointDetection
ChangePointDetection Syntax
ChangePointDetection Arguments
ChangePointDetection Input
ChangePointDetection Output
ChangePointDetection Examples
ChangePointDetection Example 1: Two Series, Default Options
ChangePointDetection Example 2: One Series, Default Options
ChangePointDetection Example 3: One Series, VERBOSE Output
ChangePointDetection Example 4: One Series, Penalty 10
ChangePointDetection Example 5: One Series, SEGMENT Output, Penalty 10
ChangePointDetection Example 6: One Series, Penalty 20, Linear Regression
ChangePointDetectionRT
ChangePointDetectionRT Syntax
ChangePointDetectionRT Arguments
ChangePointDetectionRT Input
ChangePointDetectionRT Output
ChangePointDetectionRT Examples
ChangePointDetectionRT Example 1: ChangePointThreshold 10, Window Size 3, Default Output
ChangePointDetectionRT Example 2: ChangePointThreshold 20, Window Size 3, VERBOSE Output
ChangePointDetectionRT Example 3: ChangePointThreshold 100, Window Size 3, Default Output
Convergent Cross-Mapping Functions
CCMPrepare
CCMPrepare Syntax
CCMPrepare Input
CCMPrepare Output
CCMPrepare Example
CCM
CCM Syntax
CCM Arguments
CCM Input
CCM Output
CCM Example: Simulated Data
DTW
DTW Syntax
DTW Arguments
DTW Input
DTW Output
DTW Example
Fast Fourier Transform Functions
FFT
FFT Syntax
FFT Arguments
FFT Input
FFT Output
FFT Examples
FFT Example 1: 1D Signal
FFT Example 2: 2D Signal
FFT Example 3: 3D Signal
IFFT
IFFT Syntax
IFFT Arguments
IFFT Input
IFFT Output
IFFT Examples
IFFT Example 1: 1D Signal
IFFT Example 2: 2D Signal
IFFT Example 3: 3D Signal
FrequentPaths
FrequentPaths Syntax
FrequentPaths Arguments
FrequentPaths Input
FrequentPaths Output
FrequentPaths Examples
FrequentPaths Example 1: ItemColumn
FrequentPaths Example 2: ItemDefinitionTable
FrequentPaths Example 3: GroupByColumns
FrequentPaths Example 4: SeqPatternTable
FrequentPaths Example 5: PathFilters
FrequentPaths Example 6: ClosedPattern ('true')
FrequentPaths Example 7: Use with nPath to Select Sequences
Interpolator
Interpolator Syntax
Interpolator Arguments
Interpolator Input
Interpolator Output
Interpolator Examples
Interpolator Examples Input
Interpolator Example 1: Aggregation
Interpolator Example 2: Constant Interpolation
Interpolator Example 3: Linear Interpolation
Interpolator Example 4: Median Interpolation
Interpolator Example 5: Spline Interpolation
Interpolator Example 6: Loess Interpolation
Path Analysis Functions
PathGenerator
PathGenerator Syntax
PathGenerator Arguments
PathGenerator Input
PathGenerator Output
PathGenerator Example
PathSummarizer
PathSummarizer Syntax
PathSummarizer Arguments
PathSummarizer Input
PathSummarizer Output
PathSummarizer Example
PathStart
PathStart Syntax
PathStart Arguments
PathStart Input
PathStart Output
PathStart Example
PathAnalyzer
PathAnalyzer Syntax
PathAnalyzer Arguments
PathAnalyzer Input
PathAnalyzer Output
PathAnalyzer Example
SAX
SAX Syntax (Single Input)
SAX Syntax (Multiple Inputs)
SAX Arguments
SAX Input
SAX Output
SAX Examples
SAX Example 1: Global Window, Default Output
SAX Example 2: Sliding Window, Default Output
SAX Example 3: Sliding Window, Bitmap Output
SAX Example 4: Sliding Window, Character Output
SAX Example 5: Multiple-Input Version
SeriesSplitter
SeriesSplitter Syntax
SeriesSplitter Arguments
SeriesSplitter Input
SeriesSplitter Output
SeriesSplitter Examples
SeriesSplitter Example 1: Partition Splitter
SeriesSplitter Example 2 : Using SeriesSplitter with Interpolator
SeriesSplitter Troubleshooting
Sessionize
Sessionize Syntax
Sessionize Arguments
Sessionize Input
Sessionize Output
Sessionize Example
Shapelet Functions
ShapeletUnsupervised
ShapeletUnsupervised Syntax
ShapeletUnsupervised Arguments
ShapeletUnsupervised Input
ShapeletUnsupervised Output
ShapeletUnsupervised Example
ShapeletUnsupervised Troubleshooting
ShapeletSupervised
ShapeletSupervised Syntax
ShapeletSupervised Arguments
ShapeletSupervised Input
ShapeletSupervised Output
ShapeletSupervised Example
ShapeletSupervised Troubleshooting
ShapeletSupervisedClassifier
ShapeletSupervisedClassifier Syntax
ShapeletSupervisedClassifier Arguments
ShapeletSupervisedClassifier Input
ShapeletSupervisedClassifier Output
ShapeletSupervisedClassifier Example
TimeSeriesOrders
TimeSeriesOrders Syntax
TimeSeriesOrders Arguments
TimeSeriesOrders Input
TimeSeriesOrders Output
TimeSeriesOrders Examples
TimeSeriesOrders Example 1: PartitionColumns
TimeSeriesOrders Example 2: No PartitionColumns
VARMAX
VARMAX Syntax
VARMAX Arguments
VARMAX Input
VARMAX Output
VARMAX Examples
VARMAX Example 1: No Exogenous Model
VARMAX Example 2: Exogenous Model
VARMAX Example 3: Seasonal Model, No Exogenous Model
VARMAX Example 4: All Models
VARMAX Example 5: Orders Table with One Time Series
VARMAX Example 6: Orders Table with Two Time Series
VARMAX Example 7: Existing Orders Table
Wavelet Transform Functions
DWT
DWT Syntax
DWT Arguments
DWT Input
DWT Output
DWT Example
DWT2D
DWT2D Syntax
DWT2D Arguments
DWT2D Input
DWT2D Output
DWT2D Example
IDWT
IDWT Syntax
IDWT Arguments
IDWT Input
IDWT Output
IDWT Example
IDWT2D
IDWT2D Syntax
IDWT2D Arguments
IDWT2D Input
IDWT2D Output
IDWT2D Example
nPath®
Introduction to nPath
nPath Syntax
nPath Arguments
nPath Input
nPath Output
nPath Symbols
LAG and LEAD Expressions in Symbol Predicates
LAG and LEAD Expressions Example 1
LAG and LEAD Expressions Example 2
nPath Patterns
nPath Greedy Pattern Matching
nPath Filters
nPath Filters Example
nPath Results
nPath Results Examples
nPath Results Example 1: FIRST, LAST_NOTNULL, MAX_CHOOSE, and MIN_CHOOSE
nPath Results Example 2: FIRST and Three Forms of ACCUMULATE
nPath Results Example 3: FIRST, Three Forms of ACCUMULATE, COUNT, and NTH
nPath Examples
nPath Example 1: Accumulate Pages Visited in Each Session
nPath Example 2: Find Sessions That Start at Home Page and Visit Page1
nPath Example 3: Find Paths to Checkout Page for Purchases Over $200
nPath Example 4: Mode (overlapping)
nPath Example 5: Find First Product with Multiple Referrers in Any Session
nPath Example 6: Find Data for Sessions that Checked 3-6 Products
nPath Example 7: Find Data for Sessions that Checked at Least 3 Products
nPath Example 8: Multiple Partitioned Input Tables and Dimension Input Table
Statistical Analysis
Approximate Cardinality
Approximate Cardinality Syntax
Approximate Cardinality Arguments
Approximate Cardinality Input
Approximate Cardinality Output
Approximate Cardinality Example
Approximate Percentile
Approximate Percentile Syntax
Approximate Percentile Arguments
Approximate Percentile Input
Approximate Percentile Output
Approximate Percentile Example
ConfusionMatrix
ConfusionMatrix Syntax
ConfusionMatrix Arguments
ConfusionMatrix Input
ConfusionMatrix Output
ConfusionMatrix Example
Correlation
Correlation Syntax
Correlation Arguments
Correlation Input
Correlation Output
Correlation Examples
Correlation Example 1: Include PARTITION BY Clause
Correlation Example 2: Omit PARTITION BY Clause
Cox Functions
CoxPH
CoxPH Syntax
CoxPH Arguments
CoxPH Input
CoxPH Output
CoxPH Example
CoxHazardRatio
CoxHazardRatio Syntax
CoxHazardRatio Arguments
CoxHazardRatio Input
CoxHazardRatio Output
CoxHazardRatio Examples
CoxHazardRatio Example 1: No Reference Values
CoxHazardRatio Example 2: No Reference Values, Partition by Name or ID
CoxHazardRatio Example 3: Reference Values
CoxHazardRatio Example 4: RefFeatureColumns, Partition by ID
CoxHazardRatio Example 5: Units Values
CoxSurvival
CoxSurvival Syntax
CoxSurvival Arguments
CoxSurvival Input
CoxSurvival Output
CoxSurvival Example
CrossValidation
CrossValidation Syntax
CrossValidation Arguments
CrossValidation Input
CrossValidation Output
CrossValidation Example
Distribution Matching
Hypothesis-Test Mode
Hypothesis-Test Mode Syntax
Hypothesis-Test Mode Syntax (Continuous Distributions)
Multiple-Node Data Sets
Single-Node Data Sets
Hypothesis-Test Mode Syntax (Discrete Distributions)
Multiple-Node Data Sets
Single-Node Data Sets and Any CvM Test
Hypothesis-Test Mode Arguments
Hypothesis-Test Mode Input
Hypothesis-Test Mode Output
Results (statistics and p-values)
Hypothesis-Test Mode Examples
Hypothesis-Test Mode Example 1: Normality Tests without GroupByColumns
Hypothesis-Test Mode Example 2: Normality Tests with GroupByColumns
Best-Match Mode
Best-Match Mode Syntax (DOUBLE PRECISION Input)
Best-Match Mode Syntax (INTEGER Input)
Best-Match Mode Arguments
Best-Match Mode Input
Best-Match Mode Output
Best-Match Mode Examples
Best-Match Mode Example 1: Input Values of Type DOUBLE PRECISION
Best-Match Mode Example 2: Input Values of Type INTEGER
FMeasure
FMeasure Syntax
FMeasure Arguments
FMeasure Input
FMeasure Output
FMeasure Examples
FMeasure Example 1: Output All Classes
FMeasure Example 2: Output Specified Classes
Generalized Linear Model Functions
GLM
GLM Syntax
GLM Arguments
Supported Family/Link Function Combinations
GLM Input
GLM Onscreen Output
GLM Output Table
Odds Ratio and Confidence Intervals
Goodness-of-Fit Tests
Deviance
Wald Test
Pearson’s Chi-squared Statistic
GLM Examples
GLM Example 1: Logistic Regression Analysis with Intercept
GLM Example 2: Logistic Regression Analysis with Step
GLM Example 3: Gaussian Distribution Analysis with Default Options
GLMPredict
GLMPredict Syntax
GLMPredict Arguments
GLMPredict Input
GLMPredict Output
GLMPredict Examples
GLMPredict Example 1: Logistic Distribution Prediction
GLMPredict Example 2: Gaussian Distribution Prediction
GLM2
GLM2 Syntax
GLM2 Arguments
GLM2 Input
GLM2 Output
GLM2 Examples
GLM2 Example 1: LASSO for Poisson Regression Analysis
GLM2 Example 2: Ridge for Logistic Regression Analysis
GLM2 Example 3: Elastic Net for Gaussian Regression Analysis
GLM2 Example 4: Lambda
GLM2Predict
GLM2Predict Syntax
GLM2Predict Arguments
GLM2Predict Input
GLM2Predict Output
GLM2Predict Examples
GLM2Predict Example 1: Elastic Net for Gaussian Regression Prediction
GLM2Predict Example 2: Ridge for Logistic Regression Prediction
GLM2Predict Example 3: Lambda
GLML1L2
GLML1L2 Syntax
GLML1L2 Arguments
GLML1L2 Input
GLML1L2 Output
GLML1L2 Examples
GLML1L2 Example 1: Ridge Regression, Family ('BINOMIAL')
GLML1L2 Example 2: Factor Table as InputTable
GLML1L2 Example 3: LASSO, Family ('GAUSSIAN')
GLML1L2Predict
GLML1L2Predict Syntax
GLML1L2Predict Arguments
GLML1L2Predict Input
GLML1L2Predict Output
GLML1L2Predict Examples
GLML1L2Predict Example 1: Ridge Regression, Family ('BINOMIAL')
GLML1L2Predict Example 2: LASSO, Family ('GAUSSIAN')
Hidden Markov Model Functions
Introduction to Hidden Markov Models
HMMUnsupervised
HMMUnsupervised Syntax
HMMUnsupervised Arguments
HMMUnsupervised Input
HMMUnsupervised Output
HMMUnsupervised Example: Loan Default Prediction
HMMSupervised
HMMSupervised Syntax
HMMSupervised Arguments
HMMSupervised Input
HMMSupervised Output
HMMSupervised Example: Customer Loyalty Prediction
HMMEvaluator
HMMEvaluator Syntax
HMMEvaluator Arguments
HMMEvaluator Input
HMMEvaluator Output
HMMEvaluator Example: Loan Default Prediction
HMMDecoder
HMMDecoder Syntax
HMMDecoder Arguments
HMMDecoder Input
HMMDecoder Output
HMMDecoder Examples
HMMDecoder Example 1: Loan Default Prediction (from Unsupervised Learner)
HMMDecoder Example 2: Customer Loyalty Prediction (from Supervised Learner)
HMMDecoder Example 3: Part-of-Speech Tagging
HMMDecoder Example 4: Bank Customer Churn
Histogram
Histogram Syntax
Histogram Arguments
Histogram Input
Histogram Output
Histogram Examples
Histogram Example 1: AutoBin ('Sturges')
Histogram Example 2: AutoBin ('Scott')
Histogram Example 3: BinSize, StartValue, EndValue
Histogram Example 4: CustomBinTable
KNN
KNN Syntax
KNN Arguments
KNN Input
KNN Output
KNN Example
LAR Functions
LAR
LAR Syntax
LAR Arguments
LAR Input
LAR Output
LAR Examples
LAR Example 1: FitMethod ('lar')
LAR Example 2: FitMethod ('lasso')
LARPredict
LARPredict Syntax
LARPredict Arguments
LARPredict Input
LARPredict Output
LARPredict Examples
LARPredict Example 1: Model ('diabetes_lars')
LARPredict Example 2: Model ('diabetes_lasso')
LikelihoodRatioTest
LikelihoodRatioTest Syntax
LikelihoodRatioTest Arguments
LikelihoodRatioTest Input
LikelihoodRatioTest Output
LikelihoodRatioTest Example
Linear Regression Functions
Linear Regression
Linear Regression Syntax
Linear Regression Input
Linear Regression Output
Linear Regression Example
LinRegPredict
LinRegPredict Syntax
LinRegPredict Arguments
LinRegPredict Input
LinRegPredict Output
LinRegPredict Example
Moving Average Functions
CumulativeMovAvg
CumulativeMovAvg Syntax
CumulativeMovAvg Arguments
CumulativeMovAvg Input
CumulativeMovAvg Output
CumulativeMovAvg Example
ExponentialMovAvg
ExponentialMovAvg Syntax
ExponentialMovAvg Arguments
ExponentialMovAvg Input
ExponentialMovAvg Output
ExponentialMovAvg Example
SimpleMovAvg
SimpleMovAvg Syntax
SimpleMovAvg Arguments
SimpleMovAvg Input
SimpleMovAvg Output
SimpleMovAvg Example
WeightedMovAvg
WeightedMovAvg Syntax
WeightedMovAvg Arguments
WeightedMovAvg Input
WeightedMovAvg Output
WeightedMovAvg Example
Percentiles
Percentiles Syntax
Percentiles Arguments
Percentiles Input
Percentiles Output
Percentiles Example
Principal Component Analysis (PCA) Functions
PCA
PCA Syntax
PCA Arguments
PCA Input
PCA Output
PCA Example
PCAScore
PCAScore Syntax
PCAScore Arguments
PCAScore Input
PCAScore Output
PCAScore Example
Step 1: Create Smaller Data Set
Step 2: Show How PCR Works
RandomSample
RandomSample Syntax
RandomSample Arguments
RandomSample Input
RandomSample Output
RandomSample Examples
RandomSample Example 1: Basic Sampling (Weighted)
RandomSample Example 2: KMeans++ Sampling
RandomSample Example 3: KMeans|| Sampling
Receiver Operating Characteristic (ROC)
ROC Syntax
ROC Arguments
ROC Input
ROC Output
ROC Examples
ROC Example 1: Show Only ROC Values
ROC Example 2: Show Only AUC Values
ROC Example 3: Show AUC and Gini Values
Sampling
Sampling Syntax
Unconditional Sampling, Single Sample Rate
Unconditional Sampling, Approximate Sample Size
Conditional Simple Sampling, Single Sample Rate
Conditional Sampling, Variable Sample Rates
Conditional Sampling, Approximate Sample Size
Conditional Sampling, Variable Approximate Sample Sizes
Sampling Arguments
Sampling Input
Sampling Output
Sampling Examples
Sampling Example 1: Unconditional Sampling, Single Sample Rate
Sampling Example 2: Conditional Sampling, Variable Sample Rates
Shapley Value Functions
ShapleyGenerateCombination
ShapleyGenerateCombination Syntax
ShapleyGenerateCombination Input
ShapleyGenerateCombination Output
ShapleySortCombinations
ShapleySortCombinations Syntax
ShapleySortCombinations Arguments
ShapleySortCombinations Input
ShapleySortCombinations Output
ShapleyAddOnePlayer
ShapleyAddOnePlayer Syntax
ShapleyAddOnePlayer Arguments
ShapleyAddOnePlayer Input
ShapleyAddOnePlayer Output
SQL Statements to Compute the Shapley Value
Shapley Value Functions Examples
Shapley Value Functions Example 1: ShapleyGenerateCombination, ShapleyAddOnePlayer
Shapley Value Functions Example 1 Input
Shapley Value Functions Example 1 Step 1
Shapley Value Functions Example 1 Step 2
Shapley Value Functions Example 1 Step 3
Shapley Value Functions Example 2: nPath Creates ShapleyGenerateCombination Input
Shapley Value Functions Example 2 Input
Shapley Value Functions Example 2 Step 1
Shapley Value Functions Example 2 Step 2
Shapley Value Functions Example 2 Step 3
Shapley Value Functions Example 2 Step 4
Shapley Value Functions Example 2 Step 5
Support Vector Machine (SVM) Functions
SVMSparse Functions
SVMSparse
SVMSparse Syntax
SVMSparse Arguments
SVMSparse Input
SVMSparse Output
SVMSparse Example
SparseSVMPredictor
SparseSVMPredictor Syntax
SparseSVMPredictor Arguments
SparseSVMPredictor Input
SparseSVMPredictor Output
SparseSVMPredictor Example
SVMSparseSummary
SVMSparseSummary Syntax
SVMSparseSummary Arguments
SVMSparseSummary Input
SVMSparseSummary Output
SVMSparseSummary Examples
SVMSparseSummary Example 1: OutputSummary ('true')
SVMSparseSummary Example 2: OutputSummary ('false')
SVMDense Functions
SVMDense
SVMDense Syntax
SVMDense Arguments
SVMDense Input
SVMDense Output
SVMDense Examples
SVMDense Examples Input
SVMDense Example 1: Linear Model
SVMDense Example 2: Polynomial Model
SVMDense Example 3: Radial Basis Model (RBF) Model
SVMDense Example 4: Sigmoid Model
SVMDensePredict
SVMDensePredict Syntax
SVMDensePredict Arguments
SVMDensePredict Input
SVMDensePredict Output
SVMDensePredict Examples
SVMDensePredict Example 1: Linear Model
SVMDensePredict Example 2: Polynomial Model
SVMDensePredict Example 3: Radial Basis Model (RBF) Model
SVMDensePredict Example 4: Sigmoid Model
SVMDenseSummary
SVMDenseSummary Syntax
SVMDenseSummary Arguments
SVMDenseSummary Input
SVMDenseSummary Output
SVMDenseSummary Examples
SVMDenseSummary Example 1: ShowSummary ('true')
SVMDenseSummary Example 2: ShowSummary ('false')
UnivariateStatistics
UnivariateStatistics Syntax
UnivariateStatistics Arguments
UnivariateStatistics Input
UnivariateStatistics Output
UnivariateStatistics Examples
UnivariateStatistics Example 1: ExcludeColumns, All Statistics by Default
UnivariateStatistics Example 2: TargetColumns, PartitionColumns
UnivariateStatistics Example 3: StatisticsGroups ('basic')
VectorDistance
VectorDistance Syntax
VectorDistance Arguments
VectorDistance Input
VectorDistance Output
VectorDistance Examples
VectorDistance Examples Input
VectorDistance Example 1: Default Thresholds
VectorDistance Example 2: Nondefault Thresholds
VWAP
VWAP Syntax
VWAP Arguments
VWAP Input
VWAP Output
VWAP Example
Text Analysis
Text Analysis Function Families
Latent Dirichlet Allocation (LDA) Functions
LDA
LDA Syntax
LDA Arguments
LDA Input
LDA Output
LDA Example
LDAInference
LDAInference Syntax
LDAInference Arguments
LDAInference Input
LDAInference Output
LDAInference Example
LDATopicSummary
LDATopicSummary Syntax
LDATopicSummary Arguments
LDATopicSummary Input
LDATopicSummary Output
LDATopicSummary Examples
LDATopicSummary Example 1: ShowSummary ('true')
LDATopicSummary Example 2: OutputByWord ('false')
LDATopicSummary Example 3: ShowWordWeight ('true'), ShowWordCount ('true')
LevenshteinDistance
LevenshteinDistance Syntax
LevenshteinDistance Arguments
LevenshteinDistance Input
LevenshteinDistance Output
LevenshteinDistance Example
Naive Bayes Text Classifier Functions
NaiveBayesTextClassifierTrainer
NaiveBayesTextClassifierTrainer Syntax
NaiveBayesTextClassifierTrainer Arguments
NaiveBayesTextClassifierTrainer Input
NaiveBayesTextClassifierTrainer Output
NaiveBayesTextClassifierTrainer Example
NaiveBayesTextClassifierPredict
NaiveBayesTextClassifierPredict Syntax
NaiveBayesTextClassifierPredict Arguments
NaiveBayesTextClassifierPredict Input
NaiveBayesTextClassifierPredict Output
NaiveBayesTextClassifierPredict Example
Named Entity Recognition (NER) Functions
NER Functions (CRF Model Implementation)
NERTrainer
NERTrainer Syntax
NERTrainer Arguments
NERTrainer Feature Template
Part 1 of the Example Template File
Part 2 of the Example Template File
NERTrainer Input
NERTrainer Output
NERTrainer Example
NERExtractor
NERExtractor Syntax
NERExtractor Arguments
NERExtractor Input
NERExtractor Output
NERExtractor Example
NEREvaluator
NEREvaluator Syntax
NEREvaluator Arguments
NEREvaluator Input
NEREvaluator Output
NEREvaluator Example
NER Functions (Maximum Entropy Model Implementation)
NamedEntityFinderTrainer
NamedEntityFinderTrainer Syntax
NamedEntityFinderTrainer Arguments
NamedEntityFinderTrainer Input
NamedEntityFinderTrainer Output
NamedEntityFinderTrainer Example
NamedEntityFinder
NamedEntityFinder Syntax
NamedEntityFinder Arguments
Creating the Table of Default Models
NamedEntityFinder Input
NamedEntityFinder Output
NamedEntityFinder Example
Named Entity Finder Evaluator
Named Entity Finder Evaluator Syntax
Named Entity Finder Evaluator Arguments
NamedEntityFinderEvaluatorMap Input
NamedEntityFinderEvaluatorReduce Output
Named Entity Finder Evaluator Example
NGrams
NGrams Syntax
NGrams Arguments
NGrams Input
NGrams Output
NGrams Examples
NGrams Example 1: Overlapping ('true'), TotalGramCount ('true')
NGrams Example 2: Overlapping ('false'), TotalGramCount ('false')
POSTagger
POSTagger Syntax
POSTagger Arguments
POSTagger Input
POSTagger Output
POSTagger Example
SentenceExtractor
SentenceExtractor Syntax
SentenceExtractor Arguments
SentenceExtractor Input
SentenceExtractor Output
SentenceExtractor Example
Sentiment Extraction Functions
SentimentTrainer
SentimentTrainer Syntax
SentimentTrainer Arguments
SentimentTrainer Input
SentimentTrainer Output
SentimentTrainer Example
SentimentExtractor
SentimentExtractor Syntax
SentimentExtractor Arguments
SentimentExtractor Input
SentimentExtractor Output
SentimentExtractor Examples
SentimentExtractor Examples Prerequisites
SentimentExtractor Example 1: ModelFile ('dictionary'), AnalysisType ('document')
SentimentExtractor Example 2: ModelFile ('dictionary'), AnalysisType ('sentence')
SentimentExtractor Example 3: Model ('classification:default_sentiment_classification_model.bin')
SentimentExtractor Example 4: Model ('classification:sentimentmodel1.bin')
SentimentExtractor Example 5: Dictionary Table Instead of Model File
SentimentEvaluator
SentimentEvaluator Syntax
SentimentEvaluator Arguments
SentimentEvaluator Input
SentimentEvaluator Output
SentimentEvaluator Examples
SentimentEvaluator Example 1: Model ('dictionary')
SentimentEvaluator Example 2: Model ('classification:default_sentiment_classification_model.bin')
SentimentEvaluator Example 3: Model ('classification:sentimentmodel1.bin')
SentimentEvaluator Example 4: Dictionary Table Instead of Model File
Text Classifier Functions
TextClassifierTrainer
TextClassifierTrainer Syntax
TextClassifierTrainer Arguments
TextClassifierTrainer Input
TextClassifierTrainer Output
TextClassifierTrainer Example
TextClassifier
TextClassifier Syntax
TextClassifier Arguments
TextClassifier Input
TextClassifier Output
TextClassifier Example
TextClassifierEvaluator
TextClassifierEvaluator Syntax
TextClassifierEvaluator Arguments
TextClassifierEvaluator Input
TextClassifierEvaluator Output
TextClassifierEvaluator Example
TextChunker
TextChunker Syntax
TextChunker Arguments
TextChunker Input
TextChunker Output
TextChunker Examples
TextChunker Example 1: POSTagger Output as Input
TextChunker Example 2: SentenceExtractor and POSTagger Output as Input
TextMorph
TextMorph Syntax
TextMorph Arguments
TextMorph Input
TextMorph Output
TextMorph Examples
TextMorph Example 1: SingleOutput ('true')
TextMorph Example 2: SingleOutput ('false')
TextMorph Example 3: POS ('noun', 'verb'), SingleOutput ('false')
TextMorph Example 4: POS ('noun', 'verb'), SingleOutput ('true')
TextMorph Example 5: TextMorph with POSTagger and TextTagger
TextParser
TextParser Syntax
TextParser Arguments
TextParser Input
TextParser Output
TextParser Examples
TextParser Example 1: StopWords without StemmingExceptions
TextParser Example 2: StemmingExceptions without StopWords
TextTagger
TextTagger Syntax
TextTagger Arguments
Defining Tagging Rules
TextTagger Input
TextTagger Output
TextTagger Examples
TextTagger Example 1: TaggingRules, Rules
TextTagger Example 2: Rules Table
TextTagger Example 3: TaggingRules, Dictionary File
TextTagger Example 4: TaggingRules, Superdist
TextTokenizer
TextTokenizer Syntax
TextTokenizer Arguments
TextTokenizer Input
TextTokenizer Output
TextTokenizer Examples
TextTokenizer Example 1: Chinese Tokenization
TextTokenizer Example 2: Japanese Tokenization
TextTokenizer Example 3: English Tokenization
TFIDF
TFIDF Syntax
TFIDF Arguments
TFIDF Input
TFIDF Output
TFIDF Examples
TFIDF Example 1: Tokenized Training Document Set
TFIDF Example 2: Tokenized Test Set
Cluster Analysis
Cluster Analysis
Canopy
Canopy Syntax
Canopy Arguments
Canopy Input
Canopy Output
Canopy Example
Gaussian Mixture Model Functions
GMM
GMM Syntax
GMM Arguments
GMM Input
GMM Output
GMM Examples
GMM Examples Input
GMM Example 1: Basic GMM, Spherical Covariance, Packed Output
GMM Example 2: Basic GMM, Diagonal Covariance, Unpacked Output
GMM Example 3: DP-GMM, Full Covariance, Unpacked Output
GMMPredict
GMMPredict Syntax
GMMPredict Arguments
GMMPredict Input
GMMPredict Output
GMMPredict Example
GMMProfile
GMMProfile Syntax
GMMProfile Input
GMMProfile Output
GMMProfile Examples
GMMProfile Example 1: Basic GMM, Spherical Covariance, Packed Output
GMMProfile Example 2: Basic GMM, Diagonal Covariance, Unpacked Output
GMMProfile Example 3: DP-GMM, Full Covariance, Unpacked Output
KMeans Functions
KMeans
KMeans Syntax
KMeans Arguments
KMeans Input
KMeans Output
KMeans Examples
KMeans Example 1: NumClusters, UnpackColumns ('false') by Default
KMeans Example 2: NumClusters, UnpackColumns ('true')
KMeans Example 3: InitialSeeds, ClusteredOutput
KMeans Example 4: CentroidsTable, ClusteredOutput
KMeansPlot
KMeansPlot Syntax
KMeansPlot Arguments
KMeansPlot Input
KMeansPlot Output
KMeansPlot Example
KModes Functions
KModes
KModes Syntax
KModes Arguments
Ways to Create Multiple Models
KModes Input
KModes Output
KModes Examples
KModes Example 1: InitialSeedTable
KModes Example 2: NumClusters
KModesPredict
KModesPredict Syntax
KModesPredict Arguments
KModesPredict Input
KModesPredict Output
KModesPredict Example
MinHash
MinHash Background
MinHash Syntax
MinHash Arguments
MinHash Input
MinHash Output
MinHash Example
Naive Bayes Functions
Introduction to Naive Bayes
Naive Bayes Classifier
Naive Bayes Classifier Syntax
Naive Bayes Classifier Arguments
Naive Bayes Classifier Input
Naive Bayes Classifier Output
Naive Bayes Classifier Example
NaiveBayesPredict
NaiveBayesPredict Syntax
NaiveBayesPredict Arguments
NaiveBayesPredict Input
NaiveBayesPredict Output
NaiveBayesPredict Example
Ensemble Methods
Introduction to Decision Trees
Decision Tree Functions
DecisionTree
DecisionTree Syntax
DecisionTree Arguments
DecisionTree Input
DecisionTree Output
DecisionTree Examples
DecisionTree Example 1
DecisionTree Example 2: Alternate Input Format
DecisionTree Example 3: OutputResponseProbDist
Single_Tree_Predict
Single_Tree_Predict Syntax
Single_Tree_Predict Arguments
Single_Tree_Predict Input
Single_Tree_Predict Output
Single_Tree_Predict Examples
Single_Tree_Predict Example 1
Single_Tree_Predict Example 2: OutputResponseProbDist, Responses
Decision Forest Functions
DecisionForest
DecisionForest Syntax
DecisionForest Arguments
DecisionForest Input
DecisionForest Output
DecisionForest Examples
DecisionForest Example 1: Classification Tree without Out-of-Bag Error
DecisionForest Example 2: Classification Tree with Out-of-Bag Error
DecisionForest Example 3: Regression Tree with Out-of-Bag Error
Forest_Predict
Forest_Predict Syntax
Forest_Predict Arguments
Forest_Predict Input
Forest_Predict Output
Forest_Predict Example
DecisionForestEvaluator
DecisionForestEvaluator Syntax
DecisionForestEvaluator Arguments
DecisionForestEvaluator Input
DecisionForestEvaluator Output
DecisionForestEvaluator Examples
DecisionForestEvaluator Example 1
DecisionForestEvaluator Example 2: Variable Importance
Best Practices
AdaBoost Functions
AdaBoost
AdaBoost Syntax
AdaBoost Arguments
AdaBoost Input
AdaBoost Output
AdaBoost Examples
AdaBoost Example 1
AdaBoost Example 2: OutputResponseProbDist
AdaBoostPredict
AdaBoostPredict Syntax
AdaBoostPredict Arguments
AdaBoostPredict Input
AdaBoostPredict Output
AdaBoostPredict Examples
AdaBoostPredict Example 1
AdaBoostPredict Example 2: OutputResponseProbDist, Responses
XGBoost Functions
XGBoost Background
XGBoost
XGBoost Syntax
XGBoost Arguments
XGBoost Input
XGBoost Output
XGBoost Examples
XGBoost Example 1: Binary Classification
XGBoost Example 2: Multiple-Class Classification
XGBoost Example 3: Sparse Input Format
XGBoost Troubleshooting
XGBoostPredict
XGBoostPredict Syntax
XGBoostPredict Arguments
XGBoostPredict Input
XGBoostPredict Output
XGBoostPredict Examples
XGBoostPredict Example 1: Binary Classification
XGBoostPredict Example 2: Multiple-Class Classification
XGBoostPredict Example 3: Sparse Input Format
XGBoostPredict Troubleshooting
Association Analysis
BasketGenerator
BasketGenerator Syntax
BasketGenerator Arguments
BasketGenerator Input
BasketGenerator Output
BasketGenerator Examples
BasketGenerator Example 1: Partition by tranid
BasketGenerator Example 2: Increase BasketSize
CFilter
CFilter Syntax
CFilter Arguments
CFilter Input
CFilter Output
Deleting Duplicate Output Table Rows
CFilter Examples
CFilter Example 1: Collaborative Filtering by Product
CFilter Example 2: Collaborative Filtering by Customer Segment
FPGrowth
FPGrowth Background
FPGrowth Syntax
FPGrowth Arguments
FPGrowth Input
FPGrowth Output
FPGrowth Example
Recommender Functions
KNNRecommender
KNNRecommender Syntax
KNNRecommender Arguments
KNNRecommender Input
KNNRecommender Output
KNNRecommender Example
KNNRecommenderPredict
KNNRecommenderPredict Syntax
KNNRecommenderPredict Arguments
KNNRecommenderPredict Input
KNNRecommenderPredict Output
KNNRecommenderPredict Example
WSRecommender
WSRecommender Syntax
WSRecommender Arguments
WSRecommender Input
WSRecommender Output
WSRecommender Example
Graph Analysis
Introduction to Graph Analysis Functions
AllPairsShortestPath
AllPairsShortestPath Syntax
AllPairsShortestPath Arguments
AllPairsShortestPath Input
Deleting Duplicate Edges Table Rows
AllPairsShortestPath Output
AllPairsShortestPath Examples
AllPairsShortestPath Example 1: Unweighted, Unbounded Graph
AllPairsShortestPath Example 2: Weighted, Unbounded Graph
AllPairsShortestPath Example 3: Weighted, Bounded Graph with Sources
Betweenness
Betweenness Syntax
Betweenness Arguments
Betweenness Input
Betweenness Output
Betweenness Example
Closeness
Closeness Background
Closeness Syntax
Closeness Arguments
Closeness Input
Closeness Output
Closeness Examples
Closeness Example 1: Unweighted, Unbounded Graph
Closeness Example 2: Weighted, Bounded Graph, MaxDistance=12
Closeness Example 3: Weighted, Bounded Graph, MaxDistance=8
EigenVectorCentrality
Centrality Formulas
Eigenvector and Eigenvalue
Power Iteration
Centrality Calculation
EigenVectorCentrality Syntax
EigenVectorCentrality Arguments
EigenVectorCentrality Input
EigenVectorCentrality Output
EigenVectorCentrality Examples
EigenVectorCentrality Example 1: Eigenvector Centrality (by Default)
EigenVectorCentrality Example 2: Katz Centrality
EigenVectorCentrality Example 3: Bonacich Centrality
GTree
GTree Syntax
GTree Arguments
GTree Input
GTree Output
GTree Examples
GTree Example 1: Show All Paths from Root Nodes
GTree Example 2: Show Only Paths That Cycle or End at Leaves
LocalClusteringCoefficient
LocalClusteringCoefficient Background
Unweighted, Undirected Network (BUN)
Unweighted, Directed Network (BDN)
Weighted, Directed Network (WDN)
Weighted, Undirected Network (WUN)
LocalClusteringCoefficient Syntax
LocalClusteringCoefficient Arguments
LocalClusteringCoefficient Input
LocalClusteringCoefficient Output
LocalClusteringCoefficient Examples
LocalClusteringCoefficient Example 1: WUN
LocalClusteringCoefficient Example 2: WUN with DegreeRange 3 or Greater
LocalClusteringCoefficient Example 3: WDN
LoopyBeliefPropagation
LoopyBeliefPropagation Background
LoopyBeliefPropagation Syntax
LoopyBeliefPropagation Arguments
LoopyBeliefPropagation Input
LoopyBeliefPropagation Output
LoopyBeliefPropagation Examples
LoopyBeliefPropagation Example 1: Equally Weighted Symptoms/Edges
LoopyBeliefPropagation Example 2: Unequally Weighted Symptoms/Edges
Modularity
Modularity Background
Resolution
Modularity Syntax
Modularity Arguments
Modularity Input
Modularity Output
Modularity Examples
Modularity Input
Modularity Example 1: Unweighted Edges
Modularity Example 2: Weighted Edges and Community Edge Table
Modularity Tips
Modularity Troubleshooting
NTree
NTree Syntax
NTree Arguments
Cycles in NTree
NTree Input
NTree Output
NTree Examples
NTree Example 1: Find Employee Reports
NTree Example 2: Find Employee Management Chain
NTree Example 3: Show Reporting Structure by Department
PageRank
PageRank Syntax
PageRank Arguments
PageRank Input
PageRank Output
PageRank Example
PSALSA
PSALSA Background
SALSA
PSALSA
PSALSA Syntax
PSALSA Arguments
PSALSA Input
PSALSA Output
PSALSA Examples
PSALSA Example 1: User Similarity in Social Network without Edge Weight
PSALSA Example 2: User Similarity in Social Network with Edge Weight
PSALSA Example 3: User Similarity and Product Recommendation
PSALSA Example 4: Sources and Targets Tables as Inputs
RandomWalkSample
RandomWalkSample Background
RandomWalkSample Syntax
RandomWalkSample Arguments
RandomWalkSample Input
RandomWalkSample Output
RandomWalkSample Example
Neural Networks
Neural Networks
Data Transformation
AntiSelect
AntiSelect Syntax
AntiSelect Arguments
AntiSelect Input
AntiSelect Output
AntiSelect Example
ApacheLogParser
ApacheLogParser Syntax
ApacheLogParser Arguments
ApacheLogParser Input
ApacheLogParser Output
ApacheLogParser Examples
ApacheLogParser Example 1: Default Extended/Combined Log Format
ApacheLogParser Example 2: Common logformat
ConvertToCategorical
ConvertToCategorical Syntax
ConvertToCategorical Arguments
ConvertToCategorical Input
ConvertToCategorical Output
ConvertToCategorical Example
Fellegi-Sunter Functions
FellegiSunter
FellegiSunter Syntax
FellegiSunter Arguments
FellegiSunter Input
FellegiSunter Output
FellegiSunter Examples
FellegiSunter Example 1: Unsupervised Learning
FellegiSunter Example 2: Supervised Learning
FellegiSunterPredict
FellegiSunterPredict Syntax
FellegiSunterPredict Arguments
FellegiSunterPredict Input
FellegiSunterPredict Output
FellegiSunterPredict Examples
FellegiSunterPredict Example 1: Unsupervised Learning Model
FellegiSunterPredict Example 2: Supervised Learning Model
Geometry Functions
GeometryOverlay
GeometryOverlay Syntax
UNION, INTERSECTION, DIFFERENCE and SYMDIFFERENCE
CONVEXHULL
BUFFER
GeometryOverlay Arguments
GeometryOverlay Input
GeometryOverlay Output
GeometryOverlay Examples
GeometryOverlay Example 1: Intersection
GeometryOverlay Example 2: Union
GeometryOverlay Example 3: Buffer (Single Input)
PointInPolygon
PointInPolygon Syntax
Small Polygon Count and Large Point Count
Large Polygon Count and Small Point Count
Only to Determine Relations of Points and Polygons in Same Group
PointInPolygon Arguments
PointInPolygon Input
PointInPolygon Output
PointInPolygon Examples
PointInPolygon Example 1: OutputAll ('true')
PointInPolygon Example 2: OutputAll ('false')
PointInPolygon Example 3: Passenger Coordinates as Separate Columns
IdentityMatch
IdentityMatch Syntax
When Reference Data Fits in Memory
When Reference Data Does Not Fit in Memory
IdentityMatch Arguments
IdentityMatch Input
IdentityMatch Output
IdentityMatch Example
IPGeo
IPGeo Syntax
IPGeo Arguments
IPGeo Input
IPGeo Output
IPGeo Examples
IPGeo Example 1: IP Database Stored as ML Engine File
IPGeo Example 2: Default Maxmind Geolite Database
JSONParser
JSONParser Syntax
JSONParser Arguments
JSONParser Input
JSONParser Output
JSONParser Examples
JSONParser Example 1: Nondefault Values
JSONParser Example 2: Default Values
JSONParser Example 3: Parse with Ancestor
JSONParser Example 4: ERROR_HANDLER
MultiCaseMatch
MultiCaseMatch Syntax
MultiCaseMatch Arguments
MultiCaseMatch Input
MultiCaseMatch Output
MultiCaseMatch Example
MurmurHash
MurmurHash Syntax
MurmurHash Arguments
MurmurHash Input
MurmurHash Output
MurmurHash Examples
MurmurHash Example 1: 32-Bit Hash Value (by Default)
MurmurHash Example 2: 64-Bit Value (Specified)
OutlierFilter
OutlierFilter Syntax
OutlierFilter Arguments
OutlierFilter Input
OutlierFilter Output
OutlierFilter Examples
OutlierFilter Example 1: OutlierMethod ('percentile'), ReplacementValue ('null')
OutlierFilter Example 2: OutlierMethod ('MAD-median'), ReplacementValue ('median')
Pack
Pack Syntax
Pack Arguments
Pack Input
Pack Output
Pack Examples
Pack Example 1: Default Values
Pack Example 2: Nondefault Values
Pivoting
Pivoting Syntax
Pivoting Arguments
Pivoting Input
Pivoting Output
Pivoting Examples
Pivoting Example 1: Pivot Keys
Pivoting Example 2: NumberOfRows
Scale Functions
ScaleMap
ScaleMap Syntax
ScaleMap Arguments
ScaleMap Input
ScaleMap Output
ScaleMap Examples
Scale
Scale Syntax
Scale Arguments
Location and Scale for Statistical Methods
Scale Input
Scale Output
Scale Examples
Scale Example 1: ScaleMethod ('midrange')
Scale Example 2: ScaleMethod ('midrange'), Intercept (-min)
Scale Example 3: Use Training Data to Scale Test Data
Scale Example 4: Multiple Methods
Scale Example 5: Use Scale Output in KMeans
ScaleSummary
ScaleSummary Syntax
ScaleSummary Input
ScaleSummary Output
ScaleSummary Example
ScaleByPartition
ScaleByPartition Syntax
ScaleByPartition Arguments
ScaleByPartition Input
ScaleByPartition Output
ScaleByPartition Example
StringSimilarity
StringSimilarity Syntax
StringSimilarity Arguments
StringSimilarity Input
StringSimilarity Output
StringSimilarity Examples
StringSimilarity Example 1: Compare src_text1 to tar_text
StringSimilarity Example 2: Compare src_text2 to tar_text
Unpack
Unpack Syntax
Unpack Arguments
Unpack Input
Unpack Output
Unpack Examples
Unpack Example 1: Delimiter Separates Virtual Columns
Unpack Example 2: No Delimiter Separates Virtual Columns
Unpivoting
Unpivoting Syntax
Unpivoting Arguments
Unpivoting Input
Unpivoting Output
Unpivoting Examples
Unpivoting Example 1: Specified Target Columns, Default Optional Values
Unpivoting Example 2: Specified Target Columns, Specified Optional Values
Unpivoting Example 3: Specified Target Range, Default Optional Values
URIPack
URIPack Syntax
URIPack Arguments
URIPack Input
URIPack Output
URIPack Example
URIUnpack
URIUnpack Syntax
URIUnpack Arguments
URIUnpack Input
URIUnpack Output
URIUnpack Example
XMLParser
XMLParser Syntax
XMLParser Arguments
XMLParser Input
XMLParser Output
XMLParser Examples
XMLParser Example 1: Sibling and Sibling_Delimiter
XMLParser Example 2: Ancestor
XMLParser Example 3: Expressions in Nodes and Ancestor
XMLParser Example 4: ErrorHandler
XMLParser Example 5: Grandparent, Parent, and Child Nodes
XMLRelation
XMLRelation Syntax
XMLRelation Arguments
XMLRelation Input
XMLRelation Output
XMLRelation Examples
XMLRelation Example 1: OutputType ('fulldata')
XMLRelation Example 2: OutputType ('parentchild')
XMLRelation Example 3: OutputType ('fullpath')
XMLRelation Example 4: Output Attributes as Nodes
XMLRelation Example 5: ErrorHandler
List of Functions and Their Syntax
Organization of List of Functions
Time Series, Path, and Attribution Analysis Functions
ARIMA Syntax
ARIMAPredict Syntax
Attribution
Attribution Syntax (Multiple Inputs)
Attribution Syntax (Single Input)
Burst Syntax
CCM Syntax
CCMPrepare Syntax
ChangePointDetection Syntax
ChangePointDetectionRT Syntax
DTW Syntax
DWT Syntax
DWT2D Syntax
FFT Syntax
FrequentPaths Syntax
IDWT Syntax
IDWT2D Syntax
IFFT Syntax
Interpolator Syntax
PathAnalyzer Syntax
PathGenerator Syntax
PathStart Syntax
PathSummarizer Syntax
SAX Syntax (Multiple Inputs)
SAX Syntax (Single Input)
SeriesSplitter Syntax
Sessionize Syntax
ShapeletSupervised Syntax
ShapeletSupervisedClassifier Syntax
ShapeletUnsupervised Syntax
TimeSeriesOrders Syntax
VARMAX Syntax
Path and Pattern Analysis
nPath Syntax
Statistical Analysis Functions
Approximate Cardinality Syntax
Approximate Percentile Syntax
ConfusionMatrix Syntax
Correlation Syntax
CoxHazardRatio Syntax
CoxPH Syntax
CoxSurvival Syntax
CrossValidation Syntax
CumulativeMovAvg Syntax
Distribution Matching
Best-Match Mode Syntax (DOUBLE PRECISION Input)
Best-Match Mode Syntax (INTEGER Input)
Hypothesis-Test Mode Syntax (Continuous Distributions)
Multiple-Node Data Sets
Single-Node Data Sets
Hypothesis-Test Mode Syntax (Discrete Distributions)
Multiple-Node Data Sets
Single-Node Data Sets and Any CvM Test
ExponentialMovAvg Syntax
FMeasure Syntax
GLM Syntax
GLMPredict Syntax
GLM2 Syntax
GLM2Predict Syntax
GLML1L2 Syntax
GLML1L2Predict Syntax
Histogram Syntax
HMMDecoder Syntax
HMMEvaluator Syntax
HMMSupervised Syntax
HMMUnsupervised Syntax
KNN Syntax
LAR Syntax
LARPredict Syntax
LikelihoodRatioTest Syntax
Linear Regression Syntax
LinRegPredict Syntax
Percentiles Syntax
PCA Syntax
PCAScore Syntax
RandomSample Syntax
ROC Syntax
Sampling Syntax
Unconditional Sampling, Single Sample Rate
Unconditional Sampling, Approximate Sample Size
Conditional Simple Sampling, Single Sample Rate
Conditional Sampling, Variable Sample Rates
Conditional Sampling, Approximate Sample Size
Conditional Sampling, Variable Approximate Sample Sizes
ShapleyAddOnePlayer Syntax
ShapleyGenerateCombination Syntax
ShapleySortCombinations Syntax
SimpleMovAvg Syntax
SparseSVMPredictor Syntax
SVMDense Syntax
SVMDensePredict Syntax
SVMDenseSummary Syntax
SVMSparse Syntax
SVMSparseSummary Syntax
UnivariateStatistics Syntax
VectorDistance Syntax
VWAP Syntax
WeightedMovAvg Syntax
Text Analysis Functions
LDA Syntax
LDAInference Syntax
LDATopicSummary Syntax
LevenshteinDistance Syntax
NaiveBayesTextClassifierPredict Syntax
NaiveBayesTextClassifierTrainer Syntax
Named Entity Finder Evaluator Syntax
NamedEntityFinder Syntax
NamedEntityFinderTrainer Syntax
NEREvaluator Syntax
NERExtractor Syntax
NERTrainer Syntax
NGrams Syntax
POSTagger Syntax
SentenceExtractor Syntax
SentimentEvaluator Syntax
SentimentExtractor Syntax
SentimentTrainer Syntax
TextChunker Syntax
TextClassifier Syntax
TextClassifierEvaluator Syntax
TextClassifierTrainer Syntax
TextMorph Syntax
TextParser Syntax
TextTagger Syntax
TextTokenizer Syntax
TFIDF Syntax
Cluster Analysis Functions
Canopy Syntax
GMM Syntax
GMMPredict Syntax
GMMProfile Syntax
KMeans Syntax
KMeansPlot Syntax
KModes Syntax
KModesPredict Syntax
MinHash Syntax
Naive Bayes Functions
Naive Bayes Classifier Syntax
NaiveBayesPredict Syntax
Ensemble Methods Functions
AdaBoost Syntax
AdaBoostPredict Syntax
DecisionForest Syntax
DecisionForestEvaluator Syntax
DecisionTree Syntax
Forest_Predict Syntax
Single_Tree_Predict Syntax
XGBoost Syntax
XGBoostPredict Syntax
Association Analysis Functions
BasketGenerator Syntax
CFilter Syntax
FPGrowth Syntax
KNNRecommender Syntax
KNNRecommenderPredict Syntax
WSRecommender Syntax
Graph Analysis Functions
AllPairsShortestPath Syntax
Betweenness Syntax
Closeness Syntax
EigenVectorCentrality Syntax
GTree Syntax
LocalClusteringCoefficient Syntax
LoopyBeliefPropagation Syntax
Modularity Syntax
NTree Syntax
PageRank Syntax
PSALSA Syntax
RandomWalkSample Syntax
Data Transformation Functions
AntiSelect Syntax
ApacheLogParser Syntax
ConvertToCategorical Syntax
FellegiSunter Syntax
FellegiSunterPredict Syntax
GeometryOverlay Syntax
UNION, INTERSECTION, DIFFERENCE and SYMDIFFERENCE
CONVEXHULL
BUFFER
IdentityMatch Syntax
When Reference Data Fits in Memory
When Reference Data Does Not Fit in Memory
IPGeo Syntax
JSONParser Syntax
MultiCaseMatch Syntax
MurmurHash Syntax
OutlierFilter Syntax
Pack Syntax
Pivoting Syntax
PointInPolygon Syntax
Small Polygon Count and Large Point Count
Large Polygon Count and Small Point Count
Only to Determine Relations of Points and Polygons in Same Group
Scale Syntax
ScaleByPartition Syntax
ScaleMap Syntax
ScaleSummary Syntax
StringSimilarity Syntax
Unpack Syntax
Unpivoting Syntax
URIPack Syntax
URIUnpack Syntax
XMLParser Syntax
XMLRelation Syntax
Additional Information
Changes and Additions
Teradata Links
Related Documentation
TargetColumns
Specify pairs of columns for which to calculate correlations. For each column pair, 'col_name1 :col_name2 ', the function calculates the correlation between col_name1 and col_name2 . For each column range, '[col_index1 :col_index2 ]', the function calculates the correlation between every pair of columns in the range. For example, if you specify '[1:3]', the function calculates the correlation between the pairs (1,2), (1,3), (2,3),(1,1),(3,3). The minimum value of col_index1 is 0, and col_index1 must be less than col_index2 .
KeyName
Specify the name for the CorrelationMap output table column that contains the correlations, and by which the CorrelationMap output table is partitioned.
GroupByColumns
[Optional] Specify the names of the input columns that define the group for correlation calculation. They must be the same as the columns in the input table PARTITION BY clause.
Default behavior: All input columns belong to a single group, for which the function calculates correlation.