1.1 - 8.10 - XMLParser Output - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

In these cases, the function outputs nothing:

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

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

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.