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