Hello, I have an issue wherein I am running a report within a model a

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
  • 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.
Reply
  • 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.
Children
No Data