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