////
Licensed to the Apache Software Foundation (ASF) under one
or more contributor license agreements.  See the NOTICE file
distributed with this work for additional information
regarding copyright ownership.  The ASF licenses this file
to you under the Apache License, Version 2.0 (the
"License"); you may not use this file except in compliance
with the License.  You may obtain a copy of the License at
  http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing,
software distributed under the License is distributed on an
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
KIND, either express or implied.  See the License for the
specific language governing permissions and limitations
under the License.
////
:documentationPath: /pipeline/transforms/
:language: en_US
: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.

= image:transforms/icons/rowsfromresult.svg[Get Rows from Result transform Icon, role="image-doc-icon"] Get Rows from Result

[%noheader,cols="3a,1a", role="table-no-borders" ]
|===
|
== Description

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
[%noheader,cols="2,1a",frame=none, role="table-supported-engines"]
!===
!Hop Engine! image:check_mark.svg[Supported, 24]
!Spark! image:cross.svg[Not Supported, 24]
!Flink! image:cross.svg[Not Supported, 24]
!Dataflow! image:cross.svg[Not Supported, 24]
!===
|===

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.

TIP: The Get Rows From Result is mainly available for historical reasons to build loops through workflows. Check the xref:best-practices/index.adoc[Best Practices] for better ways of looping in Hop.

== Options

[options="header"]
|===
|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    a|
Type of data.
Options include:

* Number
* String
* Date
* Boolean
* Integer
* BigNumber
* Serializable
* Binary
* Timestamp
* Internet Address
|Length    a|
* 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    a|
* For a field with the type of 'Number', enter the number of floating point digits.
Otherwise, leave blank.
|===

