EXPANDSEGMENTVALUERANGE

Overview

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

Syntax

CODE

=EXPANDSEGMENTVALUERANGE(
    ConnectionName, 
    SegmentedKeyId,
    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.
`SegmentedKeyId`	Required	The segmented key Id 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