7.00.02 - Output - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)

Several people have two labels. For example, Freddy is both a toddler and a kid, and Tom Sawyer and Becky Thatcher are both teenagers and young adults.

Multi_Case Example OutputTable
id name age labels
1 John 0.5 infant
2 Freddy 2 toddler
2 Freddy 2 kid
3 Marie 6 kid
4 Tom Sawyer 17 teenager
4 Tom Sawyer 17 young adult
5 Becky Thatcher 16 teenager
5 Becky Thatcher 16 young adult
6 Philip 22 young adult
6 Philip 22 adult
7 Joseph 25 young adult
7 Joseph 25 adult
8 Roger 35 adult
8 Roger 35 middle aged person
9 Natalie 30 adult
10 Henry 40 adult
10 Henry 40 middle aged person
11 George 50 middle aged person
12 Sir William 65 senior citizen