Clear Table

This activity assists the user in clearing the "Data" from the designated "Datatable." It
facilitates the resetting of the "Datatable" to its original state, primarily for
troubleshooting purposes, especially when the execution is within a loop.

Technical Reference

 

INPUT

DataTable: Enter the "Input datatable" variable where the input data is stored.

This parameter helps you to clear the data.

This field only accepts the "datatable" data type.

 

 

 

 

 

 

 

 

MISC

DisplayName: Displays the name of the activity. It 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's an example of how the ClearTable activity works –

In the following example, I am using the input values from the "Excel Sheet" that were
used to demonstrate the use case. For a clearer understanding, click here.
(Refer the attached sample excel sheet in the use case).

1.       Drag and drop the "ClearTable" activity onto the designer pane.

a.       This activity can only be utilized after the other “Datatable activities.”

b.       It helps to clear the data from the existing datatable.

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 for the “datatable” which is
declared here.

d.       Navigating to the “Datatable” in the properties to provide the input table
to clear the values.

i.      Here I am using the “JoinedTable” as input extracted from the
“Excel sheet” as output.

2.       Now, I have executed the workflow to clear the values from the “Datatable”.

3.      You can add “TableViewer” or “Writelog” activity to view the cleared table and
execution status of the activity.

(Below is the sample of how the “Cleared Table” will be displayed).