This activity assists in adding or updating a "New row" to the "Existing input data table"
during runtime.
Technical Reference
|
|
INPUT |
AddEmptyRow: To add an "Empty row" to the existing "Input datatable," choose this option. If not selected, the empty row will not be added. |
|
DataTable: Enter the variable for the "Input datatable" where the input data is stored. This parameter enables you to add a new column. This field only accepts data of the "datatable" type. |
||
|
InputArray: Supply the required "Input values" for the "New Row." These values should be defined using the "Array of Object" data type. (For example: {"JOHN,32, Manager"}) You can utilize either the "InputArray (hardcoded value)" or the "InputDataRow (variable)" option to insert a new row. This field exclusively accepts data of the "Array of Object" type. If left blank, it will operate with the "InputDataRow" field, if provided |
||
|
InputDataRow: Specify the "Data row" variable where the input values for the row are stored. This field only accepts the "DataRow" data type for the variable. If left blank, it will function with the "InputArray" field if provided. |
||
|
MISC |
DisplayName: Displays the name of the activity. The activity name can also be customized to help in troubleshooting. |
|
|
SkipOnError: This setting determines whether to proceed with executing the workflow even if an error occurs. It only accepts Boolean values: "True" or "False". The default setting is "False". "True": The workflow continues to the next step. "False": The workflow halts if an error is encountered. "None": If this option is left blank, the activity will inherently act as if set to "False".. |
||
|
Version: It specifies the version of the Datatable automation feature in use |
||
|
OUTPUT |
Result: It helps to view the execution state of the activity. It returns the values in Boolean format. True: It indicates the activity has been executed successfully without any error. False: It indicates that the activity has been faulted due to some unexceptional error thrown. |
* Represents mandatory fields to execute the workflow.
Here is an example demonstrating how the "Add New Row" activity functions –
In the following example, I am utilizing the input values from the "Excel Sheet" that
is used to demonstrate the use case. For a better understanding, click here.
(Refer the attached sample excel sheet in the use case).
1. Drag and drop the "AddNewRow" activity onto the designer pane.
a. This activity can only be used after performing other "Datatable activities.”
b. It helps to add or update the existing datatable with a “New row.”
c. Here I am extracting the output as “Datatable” from the “Excel sheet” using the
“ReadRanges” activity from the “Excel Automation.” (Refer the Use case to
get detailed information).
i. “JoinedTable” is the output variable for the “datatable” which has been
declared here.
d. Navigating to the “Datatable” in the properties to provide the input datatable to
add the new row.
i. Here I am using the “Datatable” as “JoinedTable” extracted as output from the
“Excel Sheet”.
e. Moving to the "InputArray" property to provide values for the row to be added
in the respective columns.
i. Here I am specifying the values as {“JOHN, Accountant, Genesis, Japan,
21/05/2016, $125,456”}.
2. Now, I have executed the workflow to add the new row to the datatable.