Output - 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

The output table shows all passengers, whether or not they are in a terminal.

PointInPolygon Example 1 Output Table (Columns 1-2)
source_location_point ref_reference_location_polygon
POINT (30 10) POLYGON ((200 0, 400 0, 400 200, 200 200, 200 0))
POINT (30 10) POLYGON ((0 0, 100 0, 100 100, 0 100, 0 0))
POINT (300 10) POLYGON ((200 0, 400 0, 400 200, 200 200, 200 0))
POINT (300 10) POLYGON ((0 0, 100 0, 100 100, 0 100, 0 0))
POINT (300 20) POLYGON ((200 0, 400 0, 400 200, 200 200, 200 0))
POINT (300 20) POLYGON ((0 0, 100 0, 100 100, 0 100, 0 0))
POINT (400 20) POLYGON ((200 0, 400 0, 400 200, 200 200, 200 0))
POINT (400 20) POLYGON ((0 0, 100 0, 100 100, 0 100, 0 0))
PointInPolygon Example 1 Output Table (Columns 3-6)
ref_terminal_name pip_flag customer_id customer_name
Terminal B 0 1 Jeff
Terminal A 1 1 Jeff
Terminal B 1 2 John
Terminal A 0 2 John
Terminal B 1 3 Maria
Terminal A 0 3 Maria
Terminal B 0 4 Macy
Terminal A 0 4 Macy