select-rows

Description

select-rows adaptor selects row(s) from a datatable and generates a new datatable based on this selection.

Inputs

data Type: datatable Required: Yes The datatable containing the rows to be selected.

begin Type: number Required: No The position of the first row to be selected. A negative number can be used to count from the end of the datatable (e.g. -5 would start at the fifth-to-last row). If unspecified, defaults to 1 (first row of data).

end Type: number Required: No The position of the last row to be selected. A negative number can be used to count from the end of the datatable. If unspecified, defaults to -1 (last row of data).

limit Type: number Required: No A positive number specifying a limit on the number of rows to be selected. If unspecified, no limit will be applied.

Outputs

data Type: datatable A datatable containing the selected rows.

Examples

Example 1: Default behaviour.

Inputs:

data:

id	code	name
1	en-GB	United Kingdom
2	tr-TR	Turkey
3	en-US	United States
4	hi-IN	India

begin: 1

end: 3

limit: null (empty)

Outputs:

data:

id	code	name
1	en-GB	United Kingdom
2	tr-TR	Turkey
3	en-US	United States

-> Selected rows from 1 to 3.

Example 2: Select rows with specific limit.

Inputs:

data:

id	code	name
1	en-GB	United Kingdom
2	tr-TR	Turkey
3	en-US	United States
4	hi-IN	India

begin: null (empty)

end: null (empty)

limit: 2

Outputs:

data:

id	code	name
1	en-GB	United Kingdom
2	tr-TR	Turkey

-> Selected rows from 1 to 2 as the limit was set to 2 rows.