Example 3: Specify Maximum Number of Rows in Any Partition - Aster Analytics

Teradata AsterĀ® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1022
lifecycle
previous
Product Category
Software

This example uses the NumberOfRows argument. With this argument, the function orders the rows as specified in the ORDER BY clause, and then converts exactly number_of_rows rows into columns. The column names are generic: value_0, value_1, and so on. If there are more than number_of_rows rows in a partition, the function ignores the extra rows. If there are fewer than number_of_rows rows in a partition, the function adds NULL values so that there are a total of number_of_rows columns.