here in the save contracts in header table am saving multiple contract_id to the table at a time. but SP will execute only one contract_id at a time to load the data to another table...
so i want to execute SP for all the contract_id... it can be possible using for each id SP has to execute ? if so let me know how can i achieve this
here we can use script tasks if required.
so i can query all the contract_ids.. but how to execute this SP for each of those items
Discussion posts and replies are publicly visible
Hi, you could use a MNI: https://docs.appian.com/suite/help/21.1/Process_Node_and_Smart_Service_Properties.html#other-tabBut i would also consider to modify the SP so it can work directly with the list of Ids
data team is on leave today! this task has to be moved to UAT by EOD
Then Multi Node Instances could be the way to go