Table

The Table Connector allows users perform various commonly used Table related operations.

How To Use

To access the Table Connector

  1. In the Toolbox expand Connectors

    Screenshot

  2. Drag the Table component and drop it under Global Objects.

    Screenshot

  3. Expand Global Objects.

  4. Double click on the DataTable component under Global Objects, User will see all the methods for data table available under Object Explorer section.

    Screenshot

SetTable

Allows a user set a table into the workflow. The SetTable method must be used prior to performing any other operations on a DataTable.

Input: Table

Screenshot

AddColumn

Allows a user add a column to a specific table.
Input: Column Name, ColumnIndex

Screenshot

AddColumns

Allows a user add multiple columns to a specific table.
Input: Column Names

Screenshot

AddRow

Allows a user add a row to a specific table.
Input: Row Data

Screenshot

ClearColumns

Allows a user clear all columns from a specific table.

Screenshot

ClearRows

Allows a user clear all rows from a specific table.

Screenshot

DeleteColumnByIndex

Allows a user delete a column based on a defines index from a specific table.
Input: Column Index

Screenshot

DeleteColumnByName

Allows a user delete a column from a specific table.
Input: Column Name

Screenshot

DeleteRow

Allows a users delete a row from a specified table.
Input: Row Index

Screenshot

FilterAndSort

Allows a user get the filter and sort table data by using expression.
Input: Expression, SetColumnName, Order

Screenshot

FindText

Allows a user find the cellvalue, RowIndex, ColIndex by defining the table text in a specified table.
Input: SearchText

Screenshot

GetCellValue

Allows users to get the value of specified table.
Input: RowIndex, ColumnIndex

Screenshot

GetCellValuesIfRowHas

Allow a user get the row data based on the text input.
Input: SearchText

Screenshot

Screenshot

GetCellValues

Allows users to get the multiple cell values based on RowIndex in a specified table. Instead of Cell Indexes a user can also use Column Name to get the data.
Input: RowIndex

Screenshot

Screenshot

GetCount

Allows a user get the number of rows and columns in a specified table.

Screenshot

GetRowData

Allows a user get the row data of a specified table.
Input: RowIndex

Screenshot

GetTable

Allows a user get the table data of a specified table.

Screenshot

GetTableAsCSV

Allows a user get the table data in the form of a CSV file.
Input: Filepath, Delimater

Screenshot

GetTableAsHTML

Allow a user get the table data in the HTML format.

Screenshot

SetCellValue

Allows a user set data into a specified table.
Input: RowIndex, ColumnIndex, Value

Screenshot

SetColumnName

Allows a user set a column name into a specified table.
Input: ColumnIndex, New ColumnName

Screenshot

SetList

Allows a user convert a defined list into a data table.
Input: Data

Screenshot

SetRowData

Allows a user set the row data into specified table.
Input: RowIndex, Data

Screenshot

ToList

Allows a user convert specified table to a list.

Screenshot

VLookUp

Allows a user retrieve the data from specified column in a table.

Screenshot

Double Click on VLookUp Component toolbar to populate the CONFIGURATION Window.
Input: Search Text, Data ColumnIndex, Search ColumnIndex, Start RowIndex
Name: Give the title Name.
Search Text: Give the text which needs to be searched in a specified table.
Data Column: Give the columnIndex for the column data needed to be retrieved.
Search Column: Give the ColumnIndex of Search Text.
StartRow: Give the RowIndex of the row needed to be searched from.

Screenshot

Click on Ok.