Write to multiple datastore entity

Just query the rows you want to update and modify the data in required columns then pass the updated row data with primary key in WDSE.

Writing to a datastore will always update the full row. This is in contrast to Appian Records, where only the provided fields will be updated.

, Is there any way so that only required columns are updated in a row, not the full row.

Not with CDTs and Data Stores.

May I ask why you are concerned?

The node is taking much time. We need to reduce the time it takes.

Rahul009 - You can create another CDT with only the required columns you intend to write (steps - download the current CDT XSD, remove the unwanted column definitions, change the name of the CDT and create a new one with this file). Create a data store entity for this CDT.

When you try writing using this new entity, only the required columns of the existing row will be updated.

Note: Use this approach only when it is extremely necessary(when you don't want to bring unwanted columns with huge data into process models).

Please explain exactly what you mean by that? Are you talking about the time it takes to execute the DB update, or about the time it takes for the node to complete?

Thanks Selvekumar, Will the table remain same and only the new CDT to be created?

Yes Stefan, it is the time it takes for the node to complete.

That has nothing to do with the actual DB update. This is the way how Appian scales to millions of active process instances compromising single node completion time.