I have to update 6rows in a table and need to create a new row with updated values in a table.
I have used query entity to fetch the data and configured in script task at output and writing into the table.but am calling same rule for 6 times to update each fields,so it may not work efficiently.can you provide me alternative way.
Thanks in advance
Discussion posts and replies are publicly visible
If you set your CDT process variable to multiple, retrieve/update all 6 rows from queryEntity, and update your Write to Datastore Entity node as multiple, you can handle all 6 rows at once. If you have any specific questions beyond that, let us know.
How is it possible on script task,how can i update a 6 rows at once?
You can retrieve and update your data via a script task, and then utilize a Write to Datastore Entity node to persist back to the DB, which can handle multiples. Can you include screen shots / code snippets of your current configuration here?