Import DataTable

This activity allows you to import data from excel or csv file into a datatable.

Using Import Datatable Activity

1.    In the Canvas Tools pane, click DataTable to expand the tool and view the associated activities.

2.    Drag the Import DataTable activity and drop on to the Flowchart designer area on the Canvas.

 

 

3.    Click File Location to import datatable. The Open windows appears.

 

 

4.    Navigate and select the required file, and then click Open.

 

NOTE:  

If your datatable is being extracted from an excel file, the Excel Sheet field appears in Import DataTable activity. In the Excel Sheet list, select the sheet or worksheet which you want to import in Automation Studio.

 

5.    Enter a name for the datatable in the Datatable Name field. A datatable is created and the selected file is imported in the datatable.

6.    Select the Has Headers option, if you want to import datatable headers.

7.    Click the (Settings) icon, and then click the required option to configure the datatable. The available options are:

a.    Configure Reader: This opens a Reader window to configure rows.

If you want data from a specified section/range of the file  to be imported in Automation Studio, enter or select the value in the Row Start and Rows To Take fields respectively.

 

 

In the Row Start/Rows To Take field, enter the value of the row. Alternatively, In the Row Start/Rows To Take list, select a parameter that holds the value. You must define the parameter in the Parameter bar to use this option and clear the If Default checkbox.

b.    Configure Headers: This opens the Headers Configuration window to configure columns.

 

 

In Headers Configuration window, the following four entities are available:

o          Name – Name of the header. You can change the name as per your requirement.

o          Data Type – The type of data for the header. You can change the data type as per your requirement.

o          Column Number – The column number of the header. This field cannot be edited.

o          Load – Select the Load option, if you want to import the column else uncheck.

 

NOTE:  

If you have tick mark Has Header check box in Import DataTable activity, then DataTable Headings appears in Headers Configuration window.

 

Import DataTable Properties

The properties of Import DataTable 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.

Excel Input

Sheet Name

The selected sheet name of the selected Excel is displayed.

File Details

File Path

The file path of the selected excel is displayed in this field. You can also define the file path directly in this field. The format to define the file is D:\MST\Stock.xls.

File Type

 The file type of the imported DataTable is stored in this field, such as, excel, csv, tab delimiters.

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 Import DataTable. You can change the name as required.

Output

Column Count

Define the parameter in argument to store the value and use the stored value in the subsequent process. In this parameter, by default column count of an imported DataTable gets stored.

Row Count

Define the parameter in argument to store the value and use the stored value in the subsequent process. In this parameter, by default row count of an imported DataTable gets stored.

Success Status

Define the parameter in argument to store the value and use the stored value in the subsequent process. In this property, you can store Boolean value. This value specifies whether the import is successful or not. As per the received value/results whether subsequent process is decided.

 

On This Page Hide

   

  Related Topics

Create DataTable

Sort DataTable

Export DataTable