GetData

This activity allows you to get value from a specific row in the datatable, according to a specified column.

Using Get Data Activity

  1. In the Canvas Tools pane, click DataTable to expand the tool and view the associated activities.
  2. Drag the Get Data activity and drop on to the Flowchart designer area on the Canvas.

 

 

  1. In the Datatable Name list, select the datatable from which you want to retrieve the data.
  2. In the Row Index field, enter or select the index of the row whose value is to be retrieved.

In the Row Index list, select a parameter that holds the value. You must define the parameter in the Parameter bar to use this option. Alternatively, In the Row Index field, enter the value of the row index and select the If Default checkbox to set it as the default value.

 

NOTE:  

In Automation Studio, Row Index count start from 0. Row index should not be greater than the number of datatable rows.

 

  1. In the Column Name list, select the name of the column whose value is to be retrieved from the row.
  2. In the Argument field, Select or enter the name of the argument in which value is set.
  3. You can use any activity to view the result, such as, WriteLine, Write To Excel.

 

Get Data Properties

The properties of Get Data activity are listed in the following table and can be edited in the Properties grid on the right pane.

 

Property Name

Usage

Control Execution

Ignore Error

When this option is set to Yes, the application ignores any error while executing the activity.

If set to NA, it bypasses the exception (if any) to let the automation flow continue; however, it marks the automation status as failure, in case of an exception.

By default, this option is set to No

Delay

Wait After (ms)

Specify the time delay that must occur after the activity is executed. The value must be in milliseconds.

Wait Before (ms)

Specify the time delay that must occur before the activity is executed. The value must be in milliseconds.

Misc

Breakpoint

Select this option to mark this activity as the pause point while debugging the process. At this point, the process freezes during execution allowing you to examine if the process is functioning as expected.

In large or complex processes, breakpoints help in identifying the error, if any.

Commented

Select this option to mark this activity as inactive in the entire process. When an activity is commented, it is ignored during the process execution.

DisplayName

The display name of the activity in the flowchart designer area. By default, the name is set as Get Data. You can change the name as required.