To me, this seems like a bit of a noobie question as I am thinking that there must be a way to do this.
I have a two dimensional list (array) which eventually will be output to a CSV file. I'm seeking to step through the list, perform a test on a particular item within the row - and then update that item accordingly.
I'm able to do this by placing the list into a lookup table and then stepping through the lookup table and using "update entry" to update the particular cell -- and then outputing the modified lookup table to a CSV file.
High level view of the steps I'm using:
- Truncate the lookup table
- Add the Workato List (2-dimensional array) to the lookup table
- Get all entries from the lookup table - to a list named "Entries"
- For each item in "Entries"
- Perform a test on the particular cell within the row of "Entries"
- If appropriate, update the cell accordingly in the lookup table using "Update Entry"
- Get all entries from the lookup table (that has now been modified)
- Compose CSV
- Upload CSV to Google Drive folder
I think Workato Data Tables would be an alternative (and possibly bettere) approach, but they are not part of our current Workato plan.
While what I've outlined above does work - it seems to be wildly inefficient to use a lookup table to be able to update a value in a two dimensional list. Is there a better way in which this can be done - to be able to directly modify particular entries within a two dimensional list?
