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
6 replies
Subscribers
7 subscribers
Views
1967 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
Hello, I have an issue wherein I am running a report within a model a
dylanf
over 11 years ago
Hello,
I have an issue wherein I am running a report within a model and saving the report output to a cdt. One of the report columns is a multi-value pv, but if I set up my cdt node to store multiple values, I can't save the report output to that node, and if I set up my cdt node to only store single values, only the first value of the multi-value pv is saved in that cdt node. I've tried some combinations of using the joinarray function within the apply function, but this isn't helping. Any help with this would be greatly appreciated.
Thanks,
Dylan...
OriginalPostID-67387
OriginalPostID-67387
Discussion posts and replies are publicly visible
Parents
0
Sathya Srinivasan
Appian Employee
over 11 years ago
OK, I get it. Your analytics node returns an array of data. But not an array of arrays. This is where the issue lies. What you need to do is take the array value returned by the analytics node for this column, iterate through each of these (they will type string), and tokenize them into an array. It'd be interesting to understand what you are trying to achieve. The other option is to store the data in a one-to-many table relation in the database and fetch is straight from the DB. If you want to establish some kind of relationshop between the data in Appian and your database entities, you can use a reference key that you can fetch via the analytis node and go to the DB with that data to get you the result set. Comparitively straight-forward and scalable than iterating through values and tokenising strings into arrays.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Sathya Srinivasan
Appian Employee
over 11 years ago
OK, I get it. Your analytics node returns an array of data. But not an array of arrays. This is where the issue lies. What you need to do is take the array value returned by the analytics node for this column, iterate through each of these (they will type string), and tokenize them into an array. It'd be interesting to understand what you are trying to achieve. The other option is to store the data in a one-to-many table relation in the database and fetch is straight from the DB. If you want to establish some kind of relationshop between the data in Appian and your database entities, you can use a reference key that you can fetch via the analytis node and go to the DB with that data to get you the result set. Comparitively straight-forward and scalable than iterating through values and tokenising strings into arrays.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data