Get Rows from Result transform Icon Get Rows from Result

Description

The Get Rows from Result transform returns rows that were previously generated by another pipeline in a workflow.

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.

Supported Engines

Hop Engine

Supported

Spark

Not Supported

Flink

Not Supported

Dataflow

Not Supported

Options

Option Description

Transform name

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

Fieldname

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

Type

Type of data. Options include:

  • Number

  • String

  • Date

  • Boolean

  • Integer

  • BigNumber

  • Serializable

  • Binary

  • Timestamp

  • Internet Address

Length

  • 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.

Precision

  • 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.