- Cloud Data Integration Current Version
- All Products
Adds a prefix to node names. Enter the prefix in the
Adds a suffix to node names. Enter the suffix in the
Exclude the nodes from the intelligent structure. Data from the node is not part of the output of the model and is not parsed during run time.
Re-include excluded nodes in the structure.
Expand the nodes to show portions of the model that are collapsed under the nodes.
Hides portions of the model that are nested under the nodes.
Change Type to String
Changes the data type of the nodes to string.
Replaces a string in node names with the string you enter in the
Withfield. Node names are not case sensitive. Names must be unique across sibling nodes, that is, nodes that reside under the same node.
Discover data type by content
Discovers the data type of numbers that are enclosed in double quotes based on the content of the node that contains the data. Applies to JSON files.
Once you apply this action to a node or to multiple nodes, you can't select to revert to the default mode of identifying numbers that are enclosed in double quotes as strings. To re-apply the default mode you must select the sample file and discover the structure again.
Extract Formatted Data
Parses the formatted data that Microsoft Excel shows. Applies to Microsoft Excel files.
Extract Unformatted Data
Parses the underlying, unformatted data. Applies to Microsoft Excel files.
Updated May 05, 2022