Components > Refining intelligent structure models > Performing actions on multiple nodes
  

Performing actions on multiple nodes

You can perform actions on multiple nodes. The actions you can depend on the type of sample data that you base the model on and on the output data type of the node.
    1Search for nodes on the Find & Actions tab and select the nodes to perform the action on in the Results list.
    2From the Action list, select one of the following actions:
    Option
    Description
    Add Prefix
    Add a prefix to node names. Enter the prefix in the With field.
    Add Suffix
    Add a suffix to node names. Enter the suffix in the With field.
    Exclude
    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.
    Include
    Re-include excluded nodes in the structure.
    Expand
    Expand the nodes to show portions of the model that are collapsed under the nodes.
    Collapse
    Hide portions of the model that are nested under the nodes.
    Update Data Type
    Change the data type of the nodes. Select the data type in the To field. Based on the data type that you select, you can edit the precision, scale, or type format of the nodes. The data type selection applies to an intelligent structure model that you export to Informatica Developer.
    Add Child Prefix
    Add a prefix to the child node names. Enter the prefix in the With field.
    Note: This command only applies prefixes to immediate child nodes. Prefixes don't apply to child nodes further down the node path.
    Add Child Suffix
    Add a suffix to the child node names. Enter the suffix in the With field.
    Note: This command only applies suffixes to immediate child nodes. Suffixes don't apply to child nodes further down the node path.
    Change Type to String
    Change the data type of the nodes to string.
    Replace
    Replace a string in node names with the string you enter in the With field. 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
    Discover 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.
    Note: 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
    Parse the formatted data that Microsoft Excel shows. Applies to Microsoft Excel files.
    Extract Unformatted Data
    Parse the underlying, unformatted data. Applies to Microsoft Excel files.
    3Click Apply to Selected.