Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
3 replies
Subscribers
8 subscribers
Views
2365 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
User Interface
I have a text type which hold multiple value (NE, SE, MW, NW, SW). i am using be
vineeta6579
over 11 years ago
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
0
evan.rust
Appian Employee
over 11 years ago
Can you expand on what you are trying to do? If you know the location of the value you are trying to return in pv!yourArray, you can simply do pv!yourArray[pv!location]. For example, if pv!yourArray={NE,SE,MW,NW,SW} and you want the 2nd value, pv!yourArray[2] will return SE.
If you would like to learn more about the index() function, please see:
forum.appian.com/.../Array_Functions
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Sathya Srinivasan
Appian Employee
over 11 years ago
When you hold an array in a text field (As single), the entire data is treated as a single text. For that reason, your array function won't work.
Try storing it in an Text Array.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 11 years ago
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)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel