1.0 - 8.00 - XMLParser Output - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Release Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
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.

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 [Column appears once for each specified parent attribute.] Attribute of extracted parent node if specified, otherwise NULL.
output_column_grandparent_node VARCHAR Name of extracted grandparent node.
grandparent_attribute VARCHAR [Column appears once for each specified grandparent attribute.] Attribute of extracted grandparent node if specified, otherwise NULL.
sibling_node_name VARCHAR [Column appears once for each specified sibling_node_name.] Name of extracted sibling node if specified, otherwise NULL.
sibling_attribute VARCHAR [Column appears once for each specified sibling_node_name attribute.] Attribute of extracted sibling node if specified, otherwise NULL.
child_node VARCHAR [Column appears once for each specified child attribute.] Name of extracted child node if specified, otherwise NULL.
child_attribute VARCHAR [Column appears once for each specified child attribute.] Attribute of extracted child node if specified, otherwise NULL.
ancestor_attribute VARCHAR [Column appears once for each specified Ancestor node.] Attribute of extracted Ancestor node if specified, otherwise NULL.
accumulate_column Same as in input table [Column appears once for each specified accumulate_column.] Column copied from input table.