7.00.02 - Output - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
Last Update
2018-04-17

The output table shows two department trees, whose roots are Dave and Peter.

nTree Example 3 Output Table
id path path2
1 Dave 1
3 Dave->Donna 1->3
7 Dave->Donna->Richard 1->3->7
2 Dave->Kim 1->2
5 Dave->Kim->Fran 1->2->5
6 Dave->Kim->Mark 1->2->6
4 Dave->Rob 1->4
9 Dave->Rob->Don 1->4->9
8 Dave->Rob->Pat 1->4->8
10 Peter 10
12 Peter->Dale 10->12
16 Peter->Dale->Gary 10->12->16
15 Peter->Dale->Jessy 10->12->15
14 Peter->Dale->Jessy->Sophia 10->12->15->14
13 Peter->John 10->13
17 Peter->John->Elizabeth 10->13->17
18 Peter->John->Richard 10->13->18
11 Peter->Sarah 10->11