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)

In these cases, the function outputs nothing:

  • No nodes_path specified by the Ancestor argument is an ancestor path.
  • No node_pair_path specified by the Nodes argument contains a parent node.
  • No node_pair_path specified by the Nodes argument contains a grandparent node.

Otherwise, the output table has a row for each node specified in the Nodes argument and for each descendant of each ancestor path specified in the Ancestor argument.

XMLParser Output Table Schema
Column Data Type Description
output_column_node INTEGER or VARCHAR Identifier of extracted node.
output_column_parent_node VARCHAR Name of extracted parent node.
parent_attribute VARCHAR Attribute of extracted parent node. The table has one column for each specified parent attribute. If no parent attributes are specified, this value is NULL.
output_column_grandparent_node VARCHAR Name of extracted grandparent node.
grandparent_attribute VARCHAR Attribute of extracted grandparent node. The table has one column for each specified grandparent attribute. If no grandparent attributes are specified, this value is NULL.
sibling_node_name VARCHAR Name of extracted sibling node. The table has one column for each specified sibling node. If no sibling nodes are specified, this value is NULL.
sibling_attribute VARCHAR Attribute of extracted sibling node. The table has one column for each specified sibling attribute. If no sibling attributes are specified, this value is NULL.
child_node VARCHAR Name of extracted child node. The table has one column for each specified child node. If no child nodes are specified, this value is NULL.
child_attribute VARCHAR Attribute of extracted child node. The table has one column for each specified child attribute. If no child attributes are specified, this value is NULL.
ancestor_attribute VARCHAR Attribute of extracted ancestor node. The table has one column for each specified ancestor attribute. If no ancestor attributes are specified, this value is NULL.
accumulate_column Same as in input table Column copied from the input table.