Frequency - INPUT - Expert Options

Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

brand
Software
prodname
Teradata Warehouse Miner
vrm_release
5.4.4
category
User Guide
featnum
B035-2300-077K
  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.