DataSetViewer

The activity can be executed only in debug mode . It helps the user to view the
“Dataset values” in a table format.

DataSet vs DataTable

"Datatables" are employed to store data comprising "Rows and Columns" and
cannot accommodate multiple datatable values. On the other hand, a "Dataset"
is utilized to contain multiple "data tables" with distinct relationships.

Technical Reference

 

 

 

 

 

INPUT

ExpirySecs: Indicate the duration in seconds for which the dataset table should be displayed.

 

Provide the time value in seconds. The default setting is “10 seconds.”

 

This field only accepts the "Integer32" datatype.

InputTable: Enter the "Input datatable" variable where the input data is stored. This parameter helps you to view the input from the table. This field only accepts the "datatable" data type.

MessageTitle: Specify the “Title” for the “Dataset” table. This field accepts only “String” datatype. 

 

 

 

 

 

 

 

 

MISC

DisplayName: Displays the name of the activity. The activity name can also be customized to help in troubleshooting.

SkipOnError: It specifies whether to continue executing the workflow even if it throws an error. This supports only Boolean value “True or False”. By default, it is set to “False.”

True: Continues the workflow to the next step
False: The workflow aborts if it throws any error.

None: If the option is specified as blank, by default the activity will perform as “False” action.

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 DataSetViewer activity works –

In the following example, I am using the input values from the “Excel Sheet” utilized
to demonstrate in the Use case. To get a better understanding, click here.
(Refer the attached sample excel sheet in the use case).

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

a.       It helps to view the “dataset” values in a table.

i.      Here I am extracting the output as “Dataset” from the “Excel sheet” using the
“ReadRanges” activity from the “Excel Automation.”

ii.      “JoinedSet” is the output that contains the “dataset” values. 

b.      Navigating to the “ExpirySecs” from the properties of the “DataSetViewer” activity.

i.      Here, the default secs is set to “10”. And I am proceeding with the same time value.   

c.       Next moving to the “InputDataset” from the property.

i.      Here, I am specifying the “InputDataset” as “JoinedSet” extracted from the
“excel sheet”.

 

d.      Moving to the “Title” from the properties.

i.      Here I am specifying the “Title” as “Output” for the “Dataset” table.

2.       Executing the workflow in “Debug” mode.

3.       Below is the sample dataset viewer output that is extracted from the
“InputDataset” value.