SUBLIST

Owned by Charles Bishop (Deactivated)
Jan 30, 2018
1 min read

Syntax

SUBLIST(<list>;<integer>)

Description

Returns the selected list starting from a specified element.

Examples

In this example the function returns the list in column1 starting from the element in position 2. Elements are stored following order: [0, 1, 2, 3, ...]

SUBLIST(#RawData!Column1;2)

Column1

SUBLIST returns

[2, 2, 2, 2, 4]

[2, 2, 4]

[green, black, orange, red][orange, red]
[24.3, 56.3, 87.4, 3.3, 11.7, 63.8, 34.7][87.4, 3.3, 11.7, 63.8, 34.7]
[true, false, false, true, true][false, true, true]