Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Big Data Management
  3. Mappings
  4. Sources
  5. Targets
  6. Transformations
  7. Data Preview
  8. Cluster Workflows
  9. Profiles
  10. Monitoring
  11. Hierarchical Data Processing
  12. Hierarchical Data Processing Configuration
  13. Hierarchical Data Processing with Schema Changes
  14. Intelligent Structure Models
  15. Stateful Computing
  16. Appendix A: Connections
  17. Appendix B: Data Type Reference
  18. Appendix C: Function Reference

Extracting an Array Element Using a Subscript Operator

Extracting an Array Element Using a Subscript Operator

Use the subscript operator in expressions to extract one or more elements of an array.
  1. In the transformation, create an output port of the same data type as the return value of the array element that you want to extract.
    To extract more than one element in an array, create an array output port. The data type of the elements in the type configuration for the array port must match the data type of the return value of the array elements.
  2. In the
    Expression
    column for the output port, click the
    Open
    button.
    The
    Expression Editor
    opens.
  3. Delete the existing expression in the editor.
  4. Click the
    Ports
    tab and select an array port.
  5. Enter one or more index values within the subscript operator.
    To extract array elements in a multidimensional array, enter index values within each subscript operator.
  6. Click
    Validate
    to validate the expression.
  7. Click
    OK
    to exit the
    Validate Expression
    dialog box.
  8. Click
    OK
    to exit the
    Expression Editor
    .


Updated July 10, 2020