EXPANDSEGMENTVALUERANGE

Overview

The EXPANDSEGMENTVALUERANGE function returns all segment values matching the specified key ID, segment number, and range expression.

Syntax

CODE

=EXPANDSEGMENTVALUERANGE(ConnectionName, SegmentedKeyName, SegmentId, Range, IncludeDescription)

Arguments

The EXPANDSEGMENTVALUERANGE function uses the following arguments:

Argument	Required/Optional	Description
`ConnectionName`	Required	The name of the connection as configured in the Connection Manager.
`SegmentedKeyName`	Required	The segmented key name for which to filter segments.
`SegmentId`	Required	The segment number for which to filter segments.
`Range`	Optional	The Velixo range* specifying which matching segments to include in the results. If left empty value, every matching segment will be included in the results. see Filtering Techniques for Velixo Functions
`IncludeDescription`	Optional	`TRUE` or `FALSE` (default) Determines if each returned segment's description should be included in the results.

Example

Given the following configuration within the ERP:

Example 1 - show segment values

CODE

=EXPANDSEGMENTVALUERANGE("Demo", "SUBACCOUNT", 1)

Description
Returns an Excel array of all possible values for the first segment of the SUBACCOUNT key ID

Result

Example 2 - show segment values and descriptions

CODE

=EXPANDSEGMENTVALUERANGE("Demo", "SUBACCOUNT", 2,,TRUE)

Description
Returns an Excel array of all possible values for the second segment of the SUBACCOUNT key ID and include the description of each segment.

Result