Correlation Example 2: Omit PARTITION BY Clause - Teradata Vantage

This example omits the PARTITION BY clause, so the function determines the correlation values for the overall population and does not group the data by state.

Input

• corr_input, as in Correlation Example 1: Include PARTITION BY Clause

SQL Call

SELECT * FROM CorrelationReduce (
  ON CorrelationMap (
    ON corr_input
    USING 
    TargetColumns ('[2:3]', 'employed:gdp', 'employed:unemployed', 'employed:armedforces')
    KeyName ('keys')
  ) PARTITION BY keys
) AS dt;

Output