Frequency - INPUT - Data Selection - Teradata Warehouse Miner

Teradata® Warehouse Miner™ User Guide - Volume 1Introduction and Profiling

Product
Teradata Warehouse Miner
Release Number
5.4.6
Published
November 2018
Language
English (United States)
Last Update
2018-12-07
dita:mapPath
rfc1538171534881.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2300
Product Category
Software
  1. On the Frequency dialog box, click on INPUT.
  2. Click on data selection.
    Frequency > Input > Data Selection

    The resulting screen has the following options available:
    • Select Input Source — Users who are not using the Teradata Profiler program may select between different sources of input. By selecting the Table option, the user can select from available databases, tables (or views) and columns in the usual manner. By selecting the Analysis option, however, the user can select directly from the output of another analysis of qualifying type in the current project. Analyses that may be selected from directly include all of the Analytic Data Set (ADS) and Reorganization analyses (except Refresh). In place of Available Databases, the user may select from Available Analyses, while Available Tables then contains a list of all the output tables that will eventually be produced by the selected analysis, or it contains a single entry with the name of the analysis under the label Volatile Table, representing the output of the analysis that is ordinarily produced by a Select statement. For more information, see INPUT Tab.
      View is only available when a single column is selected or when pairwise is selected.
    • Select Columns From a Single Table
      • Available Databases (or Analyses) — Choose the database (or analysis) from which you will select data tables.
      • Available Tables — Select the table from which you will select columns.
      • Available Columns — Select columns by highlighting and then either dragging and dropping into the Selected Columns window, or click on the arrow button to move highlighted columns into the Selected Columns window.
    • Select Frequency Style
      • Frequency Style
        • Basic — Option to count frequencies of individual column values.
        • Pairwise Frequencies — Option to count frequencies of pair-wise combinations of values of selected columns rather than individually. Not available if the Compute Cross-Tabulation option or Include cumulative measure and rank option have been selected.
        • Cross-Tabulation — Option to count frequencies of combinations of values of selected columns rather than individually. Results in an error if columns have been selected in Selected Cross Columns/Aliases, and not available if the Compute Pairwise Frequencies option has been selected.
    • Select Optional Columns
      • Statistics Columns — If Basic Frequency Style is selected, expand the Statistics Columns selector by clicking on the “double-up-arrow” (). Select columns by highlighting and then either dragging and dropping into the Statistics Columns window, or click on the arrow button to move highlighted columns into the Statistics Columns window.
      • Pairwise Columns — If Pairwise Frequency Style is selected, expand the Pairwise Columns selector by clicking on the “double-up-arrow” (). Select columns by highlighting and then either dragging and dropping into the Pairwise Columns window, or click on the arrow button to move highlighted columns into the Pairwise Columns window. In this manner, the pairwise combinations of Selected Columns and Pairwise Columns is taken. Otherwise, only the combinations of Selected Columns is taken.