EXPANDSEGMENTVALUERANGE

Overview

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

Syntax

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

Arguments

The EXPANDSEGMENTVALUERANGE function uses the following arguments:

Argument	Required/Optional	Description
`ConnectionName`	Optional	Provide one of the following values: Connection name as defined in Connection Manager. Velixo range expression defining a set of connection names. An array of settings as described in the Multiple connections per formula article. We recommend using the VX.SETTINGS function to construct the array. OR Omit the argument to return results for all compatible connections with default aggregation settings.
`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:

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/5McS8qY0fHKz4xb3BhCvfXXtb5Q5FZPjQA.png

Example 1 - show segment values

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

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

Result

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/Mgmu3r8t2WEPlhhTgJfgsfg4R0fLNsU2EA.png

Example 2 - show segment values and descriptions

=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

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/BvO2i9Tz45S9CHKbm76x25ceiyALZiQAXQ.png