I have a text type which hold multiple value (NE, SE, MW, NW, SW). i am using be

I have a text type which hold multiple value (NE, SE, MW, NW, SW). i am using below function to extract value of this array. but its not working.

index(pv!selectedCustomerIdentifier,2,1). output of index function is same as input which i am giving.....

OriginalPostID-95456

OriginalPostID-95456

  Discussion posts and replies are publicly visible

Parents
  • As Sathya indicates the fact that the index function is returning the same as the input indicates one of two things:

    1. Your process variable is not marked as multiple
    2. The content of the variable is not an array but a single text
    ---> 2.1 This is how a text array is provided ={"NE", "SE","MW", "NW", "SW"}
    ---->2.1 Or if passed through the UI
    NE; SE,MW, NW; SW

    You can actually prove this theory by using the split function:

    =index(split(pv!selectedCustomerIdentifier,";"),2,1)

    or, if the values are coma separated:

    =index(split(pv!selectedCustomerIdentifier,","),2,1)
Reply
  • As Sathya indicates the fact that the index function is returning the same as the input indicates one of two things:

    1. Your process variable is not marked as multiple
    2. The content of the variable is not an array but a single text
    ---> 2.1 This is how a text array is provided ={"NE", "SE","MW", "NW", "SW"}
    ---->2.1 Or if passed through the UI
    NE; SE,MW, NW; SW

    You can actually prove this theory by using the split function:

    =index(split(pv!selectedCustomerIdentifier,";"),2,1)

    or, if the values are coma separated:

    =index(split(pv!selectedCustomerIdentifier,","),2,1)
Children
No Data