Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Data Engineering Integration
  3. Mappings
  4. Mapping Optimization
  5. Sources
  6. Targets
  7. Transformations
  8. Python Transformation
  9. Data Preview
  10. Cluster Workflows
  11. Profiles
  12. Monitoring
  13. Hierarchical Data Processing
  14. Hierarchical Data Processing Configuration
  15. Hierarchical Data Processing with Schema Changes
  16. Intelligent Structure Models
  17. Blockchain
  18. Stateful Computing
  19. Appendix A: Connections Reference
  20. Appendix B: Data Type Reference
  21. 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 September 28, 2020