7.00.02 - Input - 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)
nPath LAG and LEAD Expressions Example 2 Input Table aggregate_clicks
userid sessionid productname pagetype clicktime referrer productprice
1039 1 sneakers home 2009-07-29 20:17:59 Nike 100
1039 2 books home 2009-04-21 13:17:59 BarnesNoble 300
1039 3 television home 2009-05-23 13:17:59 Bestbuy 500
1039 4 envelopes home 2009-07-16 11:17:59 Staples 10
1039 4 envelopes home1 2009-07-16 11:18:16 Staples 10
1039 4 envelopes page1 2009-07-16 11:18:18 Staples 10
1039 5 bookcases home 2009-08-19 22:17:59 Ikea 150
1039 5 bookcases home1 2009-08-19 22:18:02 Ikea 150
1039 5 bookcases page1 2009-08-19 22:18:05 Ikea 150
1039 5 bookcases page2 2009-08-22 04:20:05 Ikea 150
1039 5 bookcases checkout 2009-08-24 14:30:05 Ikea 150
1039 5 bookcases page2 2009-08-27 23:03:05 Ikea 150
1040 1 tables home 2009-07-29 20:17:59 Ikea 250
1040 2 Appliances home 2009-04-21 13:17:59 GE 1500
1040 3 laptops home 2009-05-23 13:17:59 Dell 800
1040 4 chairs home 2009-07-16 11:17:59 Staples 400
1040 4 chairs home1 2009-07-16 11:18:16 Staples 400
1040 4 chairs page1 2009-07-16 11:18:18 Staples 400
1040 5 cellphones home 2009-08-19 22:17:59 Samsung 600
1040 5 cellphones home1 2009-08-19 22:18:02 Samsung 600
1040 5 cellphones page1 2009-08-19 22:18:05 Samsung 600
1040 5 cellphones page2 2009-08-22 04:20:05 Samsung 600
1040 5 cellphones checkout 2009-08-24 14:30:05 Samsung 600
1040 5 cellphones page2 2009-08-27 23:03:05 Samsung 600
... ... ... ... ... ... ...