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
7 replies
Subscribers
6 subscribers
Views
2960 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
I have a process variable CDT which has following in it: [docTitile=ABC, do
gaurava322
over 8 years ago
I have a process variable CDT which has following in it:
[docTitile=ABC, docUpload=, docName=Account, docCategory=Test1, docType=Test3, dateIssued=5/5/2016, status=Completed]
[docTitile=DEF, docUpload=Mandatory, docName=Cheque, docCategory=Test2, docType=Test4, dateIssued=5/5/2016, status=Pending]
[docTitile=DEF, docUpload=, docName=Fee, docCategory=Test5, docType=Test6, dateIssued=5/5/2016, status=Pending]
I need to update the rows where column "docUpload" is blank and need to update it with value "Optional". Is this can be achieved by script task. If yes, please provide your suggestions.
OriginalPostID-212735
OriginalPostID-212735
Discussion posts and replies are publicly visible
Parents
0
vimalkumars
Certified Lead Developer
over 8 years ago
You can also identify indices of the blank values and then update the values in that indices by using the below expression
To find indices:
wherecontains(tostring(null),touniformstring(index(YourCDTVariable,"docUpload", {})))
To update:
updatearray(index(local!a,"docUpload", {}),local!emptyindices,"Optional"))
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
vimalkumars
Certified Lead Developer
over 8 years ago
You can also identify indices of the blank values and then update the values in that indices by using the below expression
To find indices:
wherecontains(tostring(null),touniformstring(index(YourCDTVariable,"docUpload", {})))
To update:
updatearray(index(local!a,"docUpload", {}),local!emptyindices,"Optional"))
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data