Get Rows from Result transform Icon Get Rows from Result


The Get Rows from Result transform returns rows that were previously generated by another pipeline in a workflow. You do not need to define any fields in the Get rows from result transform to retrieve all data row fields.

Supported Engines

Hop Engine



Not Supported


Not Supported


Not Supported

The rows were passed on to this transform using either the Copy rows to result transform or the Pipeline Executor transform.

You can enter the metadata of the fields you are expecting from the previous pipeline in a workflow.

The Get Rows From Result is mainly available for historical reasons to build loops through workflows. Check the Best Practices for better ways of looping in Hop.


Option Description

Transform name

Name of the transform this name has to be unique in a single pipeline.


Name of the field that contains the rows from the previous result.


Type of data. Options include:

  • Number

  • String

  • Date

  • Boolean

  • Integer

  • BigNumber

  • Serializable

  • Binary

  • Timestamp

  • Internet Address


  • For a field with the type of 'Number', enter the total number of significant figures in a number.

  • For a field with the type of 'String', enter the total length of the string.

  • For a field with type of 'String', enter the length of output of the string.


  • For a field with the type of 'Number', enter the number of floating point digits. Otherwise, leave blank.

Metadata Injection Support

All fields of this transform support metadata injection. You can use this transform with ETL Metadata Injection to pass metadata to your pipeline at runtime.