Write to multiple datastore entity

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).

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).

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

Yes, the table will remain the same.