From the File menu, select Add New Analysis.
Add New Analysis
- Double-click or highlight the desired analysis and click OK. The window for the selected analysis appears.
Click the Variable Creation analysis icon.
One or more additional fields are displayed, as shown in the following example.Add New Analysis: Variable Creation
- Analysis name — This is the name to assign to the new analysis. The default shown is based on the type of analysis and a counter to make it unique within the project.
Analysis template — This is an optional template indicator (default is none). When a template type is selected here and OK is selected, two or more analyses are created as called for by the template, with connecting fields and required options pre-set. Immediately after the analyses are created, a pop-up viewer is displayed with further instructions to be followed by the user to complete the template. The templates provided include:
- Query with Derived Table — A derived query analysis and base query analysis are created.
- Query with Subquery — A subquery analysis and base query analysis are created.
- With Query — A With query analysis and base analysis are created.
- With Recursive Query — A With Seed query, With Recursive query and base query analysis are created.
- With Recursive View — A With Seed query, With Recursive query and base view analysis are created.
- Union of Queries — Two analyses to combine with a set operator are created.
Operator — This drop-down selector is displayed only when the requested template type requires it. The possible values are outlined below.Query with Subquery
- Is Null
- Is Not Null
- Not Between
- Not Exists
- Not In
- Not Like
The SQL predicate operators above are the operators most frequently used with subqueries. See the Variable Creation – INPUT – Variables – SQL Elements section in the Teradata Warehouse Miner User Guide (Volume 2), B035-2301, for more information about these SQL operators.Union of Queries
- UNION ALL
- INTERSECT ALL
- EXCEPT ALL
The keyword ALL in the list above means to retain duplicate rows in the result set. The UNION keyword indicates that rows output from both the first and second analysis should be included in the answer set. INTERSECT is used to indicate that only rows included in both input data sets should be included in the output data set. And finally, EXCEPT is used to indicate that all rows from the first data set should be included in the output data set except those occurring in the second data set.