when we apply multi-select dropdown .. comma separated value is getting store in table in single row ..but i how to put in different rows.
Output i am getting
Discussion posts and replies are publicly visible
Check out Appian's text function "fn!split" - it takes a text string and turn it into an array based on a given delimiter.
I've found that a better option would be to assemble a text array and then create a JSON string -- the split() method will work, but there's a lot of overhead involved in creating the array string then re-parsing it back to the plain array when needed, and a!toJson() / a!fromJson() take care of all of that implicitly.
I think the real question here is what do you expect your resulting table structure to be? Are you aiming to have multiple rows representing each selection? In general SQL tables are flat, meaning if you want to store multiple values in a fully-normalized way, you'd need to create a new table to store many rows per row in the parent table (i.e. in the new sub-table, you'd have 1 row for each of your selected "field values" selections, and each row would also contain a Foreign Key pointing to the PK of the related row in the parent table). This sounds complicated but it's not that hard to do once you're used to it.
However if you're hoping to just store all selected values i.e. in a text field in the original table row (it's a less recommended approach, but will do in a pinch especially if your data set will never get very large), you can go with the approach of just making a string of the IDs, such as what Dan suggested already (though per my reply, i still suggest making a JSON string and storing that).
© 2023 Appian. All rights reserved.