Frequency - INPUT - Expert Options - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling
Product
Teradata Warehouse Miner
Release Number
5.4.4
Published
July 2017
ft:locale
en-US
ft:lastEdition
2018-05-03
dita:mapPath
wbc1492033894304.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2300
Product Category
Software
  1. On the Frequency dialog box, click on INPUT.
  2. Click on expert options.
    Frequency > Input > Expert Options

    This screen has the following options:
    • WHERE Clause text — Option to have the specified SQL WHERE clause generated within the Frequency SQL to filter rows selected for analysis (for example, cust_id > 0).
    • HAVING Clause text — Option to have the specified SQL HAVING clause generated within the Frequency SQL to restrict returned aggregations (for example, xpct > 1). This option is enabled only if Only include frequency values … is not checked.
    • QUALIFY Clause text — Option to have the specified SQL QUALIFY clause generated within the Frequency SQL to restrict OLAP results returned (for example, RANK(xval) ≤ 1000). This option is enabled only if Include rank … is checked and Only include the top 'x' frequency values is not checked.