Getting Started with DataTable

 

What is DataTable Automation?

DataTable Automation assists you to work with tabular data where information is stored in the format of rows and columns and acts as a database or simple spreadsheet.

 

The out-of-the-box activities available within the DataTable canvas tool are:

Create DataTable -  Creates a new customized data table in the Automation Studio without having dependency on any application such as, excel.

Add Row - Adds a new row in the datatable.

Remove Row - Deletes a row from the datatable.

Update Data - Updates the values in an existing datatable.

Clear DataTable - Clears all the data in the datatable.

Get Data - Gets value from a specific row in the datatable according to a specified column.

Import DataTable - Imports data from excel or csv file into a datatable.

Export DataTable -  Exports datatable to excel, csv, or tab delimited file.

Sort DataTable - Sorts the data in a datatable based on the values of the specified columns.

Count Row Column - Counts the number of rows and columns  of the datatable.

 

Benefits

Following are the benefits of using DataTable Automation:

  • Keeps data organized
  • Stores the data in a simple spreadsheet and act as database for stored data
  • Fast and efficient readability

 

Points to Remember

Ensure following points while utilizing data table activities:

  • The row index count starts from 0.
  • The Import DataTable activity can import excel or CSV files.
  • The Export DataTable activity supports excel, csv and tab delimited file types.

 

DataTable Automation Journey

 

Click here to learn more about data table automation through step by step example of datatable.