Search: insert-data-table

Input Data Table (DataTable)* - The DataTable variable that you want to filter. This field supports

. Output Data table (DataTable) - the filtered Data table as an output of the activity, stored

to consider data security requirements before using it. Display Name (String) - The name of this activity. You

Filter Data Table

filter data table.jpg

Data Table

.png||height="341" width="482"]] == **Properties** == **Input** * **Data Table (DataTable

. **Output** * **Data table (DataTable)** - the filtered Data table as an output of the activity, stored

button so that you can access the wizard and customize your settings at any time. [[[[image:filter data

supports only strings and String variables. E.g: “WordIWantToSearch” Data Table (DataTable

to organize and structure your code better. Eg: Look up the data table Output Cell Value - Optional

for. This field supports only strings and String variables. Eg: “Name of column” Data Column (DataColumn

Look Up Data Table

look up data table.jpg

Data Table

Look Up Data Table

only strings and String variables. E.g: “WordIWantToSearch” * **Data Table (DataTable

the data table **Output** * **Cell Value** - Optional. The value found in the cell that has the Row

in the Target Column property category. [[[[image:look up data table.jpg||class="img-thumbnail

of the XWiki Syntax you can use in wiki pages (headings, images, tables). Headings XWiki offers 6 levels

1 Numbered list Item Subitem Item Subitem Mixed list Item 1 Item 2 Item 3 Item 4 Item 5 Tables You can create tables right into wiki pages: Table with headers in the top row table header table

>>XWiki.XWikiSyntax]] you can use in wiki pages (headings, images, tables). = Headings = XWiki offers 6 levels

. Item 1 11. Item 2 11*. Item 3 11*. Item 4 1. Item 5 = Tables = You can create tables right into wiki pages: == Table with headers in the top row == |= table header |= table header |= table header | cell

statement on a database. For UPDATE, INSERT, and DELETE statements, the return value is the number of rows

) In the body of activity Configure Connection - Set connection string, data source, data provider. Edit

if you want to publicize it. Remember to consider data security requirements before using it. Display

. For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command

]] (* for Mandatory) == **In the body of activity** == * **Configure Connection **- Set connection string, data source, data provider. [[image:https://docs.akabot.com/bin/download/Activities/Database/Activities

in the .csv file that contains the job data. By default, this property is set to COMMA. The following options

in the .csv file that contains job data. File Path – The full path to the .csv file that contains the job data. Only String variables supported. Line Ending - Specifies the line ending which marks the end of a data

for columns in the .csv file that contains the job data. By default, this property is set to **COMMA

operations. The field values must also be found in the .csv file that contains job data. * **File Path **– The full path to the .csv file that contains the job data. Only String variables supported. * **Line Ending

it. (* for Mandatory) In the body of activity URL (String) - Insert a specified URL in the container. Ex: “https

(Browser)* - Insert the specified browser in which activities could be active. URL (String)* - Provide

want to publicize it. Remember to consider data security requirements before using it. Display Name

-20220506110901-1.png]] (* for Mandatory) **In the body of activity** * **URL (String)** - Insert

Browser (Browser)*** - Insert the specified browser in which activities could be active. * **URL (String

to consider data security requirements before using it. * **Display Name (String)** - The name

Add Data Column Add Data Row Build Data Table Clear Data Table Filter Data Table For Each Row Generate Data Table Get Row Item Join Data Tables Look Up Data Table Merge Data Table Output Data Table Remove Data Column Remove Data Row Remove Duplicated Rows Sort Data Table

Data Table

/Activities/Add%20Data%20Row/]] * [[Build Data Table>>url:https://docs.akabot.com/bin/view/Activities/Data%20Table/Activities/Build%20Data%20Table/]] * [[Clear Data Table>>url:https://docs.akabot.com/bin/view/Activities/Data%20Table/Activities/Clear%20Data%20Table/]] * [[Filter Data Table>>url:https://docs.akabot.com

duplicate rows in the data table. (* is mandatory) Properties Input Data Table (DataTable)* - The data table you want to check. Misc Public (Checkbox) - Check if you want to publicize it. Remember

Rows. Output Output Data Table(DataTable) - The column value from the specified DataRow.

Data Table

" %) ((( RCA.Activities.Core.RemoveDuplicatedRows == **Description** == This activity allows you to remove duplicate rows in the data table

** == **Input** * **Data Table (DataTable)* **- The data table you want to check. **Misc** * **Public

** * **Output Data Table(DataTable) **- The column value from the specified DataRow. ))) {{velocity

and choose data type is "Table". Step 3: (This step is optional) Turn on button "Required" to set require

and data type for each column Step 6: Click "Save" button Table of Content

and Table Field 1. Add Form Field Step 1: On Add Learning Instance screen, click "Add Field" button

the table name on "Label" field and choose data type is "Table". ))) [[image:image-20221028164141-11.png

types of fields: Form Field and Table Field == **1. Add Form Field** == (% class="box infomessage

the field name on "Label" field and choose data type for field on "Data Type" field ))) [[image:image

of the activity to organize and structure your code better. E.g: Get the data table Public (Checkbox) - If you

using it. Output Data Table (DataTable)- The Table is extracted from the Word Document and stored

RCA.Activities.Word.GetTable Description This activity allows you to retrieve a table from

Get Table

Get Table

the data table * **Public (Checkbox) **- If you check it, the data of this activity will be shown in the log. Be careful, consider data security before using it. **Output** * **Data Table (DataTable

== **Description** == This activity allows you to retrieve a table from a Word Document and return