For example, I have process variables arrays
name : {"a","b","c","d"},
age : {1,2,3,4},
email : {"@e","@r","@t","@w"}and I have a CDT which has {name,age,email} How can I save those array values in my CDT in process model? bcz when I try to use script task to save the array values in CDT and write in the db using cdt then only first row is getting written in db.
Discussion posts and replies are publicly visible
It is not performant or considered best practice to have a single field contain an array of items. I would recommend you go back to your initial interface and update the rule input to be an array. Check out this pattern on Appian Documentation https://docs.appian.com/suite/help/22.4/recipe-add-edit-and-remove-data-in-an-inline-editable-grid.html and look at how local!employees (line 11) is creating a list of arrays. Once you have reviewed the pattern to see how new employees are added to the local variable, you can reconstruct your interface to allow the same behavior. Eventually, you can pass that array of items into the process where the Write to DSE node will see that each array should represent a row in the db.