7.00.02.01 - Example 3 Input Table - Aster R

Teradata Aster® R User GuideUpdate 3

prodname
Aster R
vrm_release
7.00.02.01
created_date
December 2017
category
Programming Reference
User Guide
featnum
B700-1033-700K

This is the "Fruit_sales" table used as the input table in this example.

  date orderid itemid cost salesprice
1 5/1/2010 100 apples 2.64 3.61
2 5/1/2010 100 oranges 1.32 1.46
3 5/1/2010 101 grapes 2.09 2.38
4 5/1/2010 101 oranges 1.02 1.45
5 5/1/2010 101 apples 1.33 1.65
6 5/1/2010 102 grapes 1.91 2.40
7 5/1/2010 102 bananas 2.45 3.29
8 5/1/2010 103 kiwis 1.99 2.33
9 5/1/2010 103 grapes 3.25 3.95
10 5/1/2010 103 apples 1.80 1.97
11 5/1/2010 103 peaches 1.15 1.47
12 5/1/2010 103 plums 3.20 3.84
13 5/2/2010 104 apples 1.87 3.21
14 5/2/2010 104 grapes 2.04 3.23
15 5/2/2010 105 bananas 2.78 2.82
16 5/2/2010 105 kiwis 2.96 4.35
17 5/2/2010 105 peaches 3.39 3.90
18 5/2/2010 105 plums 2.32 3.23
19 5/2/2010 105 raspberries 2.46 2.95
20 5/2/2010 105 blueberries 3.50 3.69
21 5/2/2010 105 grapefruit 3.66 4.40
22 5/3/2010 106 bananas 2.74 3.15
23 5/3/2010 106 kiwis 0.95 1.15
24 5/3/2010 106 pears 1.07 1.28
25 5/3/2010 107 grapefruit 0.76 1.26
26 5/3/2010 107 tangerines 0.87 1.19
27 5/3/2010 107 oranges 1.11 1.50
28 5/3/2010 107 pears 3.90 4.36
29 5/3/2010 107 plums 3.13 5.36
30 5/4/2010 108 blueberries 3.11 5.06
31 5/4/2010 108 raspberries 2.54 2.86
32 5/4/2010 108 peras 2.86 4.83
33 5/4/2010 108 plums 2.46 3.76
34 5/4/2010 109 peaches 2.66 2.73
35 5/4/2010 109 plums 1.22 1.33