Set Action Activity

The Set Action activity enables users to write a specified value to a particular cell within a designated dataset. This activity is crucial for updating or populating datasets with new or modified information during process execution.

Field	Description	Requirement
Dataset name	The reference name of the target dataset.	Required
Column	The name or zero-based index of the column to update.	Required
Row	The zero-based index of the row to update.	Optional
Value	The value to be written to the specified cell in the dataset.	Required
Type	The data type of the value being set.	Required

Action Types & Examples

STRING

Format: string
Example Result: "Robusta"

INTEGER

Format: digit
Example Result: "0"

DOUBLE

Format: decimal number
Example Result: "123.45"

DATE

Format: date string
Example Result: "2023-10-27"

BOOLEAN

Format: boolean
Example Result: "true"

Implementation Examples

Field Setup - Dataset name: newDS - Column: 0, Name, 0:3 - Row: 0 - Value: Robusta, ${Name} - Type: STRING, INTEGER, DOUBLE, DATE, BOOLEAN

Execution Parameters - Example 1: Setting a string value in a specific cell. - Dataset name: newDS - Column: Name - Row: 0 - Value: Robusta - Type: STRING - Example 2: Setting a dynamic integer value using a column index. - Dataset name: newDS - Column: 0 - Row: 0 - Value: ${CountResult} - Type: INTEGER

Technical Notes

Column indices are zero-based, meaning the first column is 0. Row indices are also zero-based, with the first row being 0. Dynamic values can be provided using variable expressions, such as ${VariableName}, which will be resolved at runtime.