Posted Tue, 05 Jul 2022 20:06:43 GMT by David Gardiner Senior Decision Support Analyst


I have a problem where some database items return multiple values in a column that can be seen onscreen by expanding the field.  I need to treat these values as individual items when utilizing the data later on.  I thought an array would work but I may not understand what an array is for, or maybe, just not how to set it up properly.

This is what I'm seeing in the database for "current value":


So can I do anything to separate this out, or do I have to do something prior to obtaining the database information from my spreadsheet?

Thanks in advance, to anyone who can help!

Posted Thu, 21 Jul 2022 16:42:39 GMT by Alex Escalante
Hello David,

 If you have your list in a variable, you can use our "loop list" action to process one item at a time.

Attached is a small sample code that shows how this would work. Make sure to change the delimiter to "new line":

If you have your list in a dataset, you would use the "loop dataset" action. The concept would remain the same.

Please let us know if this works for you.
Posted Thu, 21 Jul 2022 16:46:20 GMT by Alex Escalante
Sample task 

You must be signed in to post in this forum.