検索：output-data-table

can edit the name of the activity to organize and structure your code better. Eg: Output data table

RCA.Activties.Core.OutputDataTable Description This activity allows you to write a Data Table to a string using the CSV format. (* is mandatory) Properties Input Data Table (DataTable)* - The data

Output Data Table

ouput data table.jpg

Output Data Table

Data Table

** * **Data Table (DataTable)*** - The data table that you want to output. **Misc** * **Public (Checkbox

and structure your code better. **Eg**: Output data table **Output** * **Text **- The output of the Data

" %) ((( RCA.Activties.Core.OutputDataTable == **Description** == This activity allows you to write a Data Table to a string using

Table Output Data Table (DataTable) - The Data Table variable that contains the generated table.

RCA.Activities.Core.BuildDataTable Description This activity allows you to create a new Data Table with different settings. In the body of activity Data Table - Click to add/ remove columns

Build Data Table

build data table.jpg

Data Table

Build Data Table

to organize and structure your code better. **Eg**: Build Data Table **Output** * **Data Table (DataTable

" %) ((( RCA.Activities.Core.BuildDataTable == **Description** == This activity allows you to create a new Data Table with different

]] == **In the body of activity** == **Data Table **- Click to add/ remove columns, update column name/ column type

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

%20Table/]] * [[Output Data Table>>url:https://docs.akabot.com/bin/view/Activities/Data%20Table/Activities

/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

/FULL. Output Output Data Table (DataTable) - The output in the type of DataTable.

Join Table Wizard - set join condition and join type Properties Input Data Table1 (DataTable

supports only DataTable variables. Data Table2 (DataTable)* - The second table that you want to use

Join Data Tables

join data table.jpg

Data Table

Join Data Table

Table\ **Option** * **Join Type (JoinType)** - INNER/LEFT/FULL. **Output** * **Output Data Table

" %) ((( RCA.Activities.Core.JoinDataTables == **Description** == This activity allows you to add different data from different tables

"]]>>attach:join data table.jpg]] (* is mandatory) == **In the body of activity** == **Join Table Wizard - **set

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

. (* is mandatory) In the body of activity Filter Wizard - Set filter for rows, set output columns Properties Input Data Table (DataTable)* - The DataTable variable that you want to filter. This field supports

Filter Data Table

filter data table.jpg

Data Table

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

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

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

the name of the activity to organize and structure your code better. Eg: Sort Data table Output Output

RCA.Activities.Core.SortDataTables Description This activity allows you to sort data tables

Input Data Table (DataTable)* - The data table variable you want to sort. This field supports only

Sort Data Table

sort data table.jpg

Data Table

Sort Data Table

of the activity to organize and structure your code better. Eg: Sort Data table **Output** * **Output Data Table

" %) ((( RCA.Activities.Core.SortDataTables == **Description** == This activity allows you to sort data tables in ascending or descending

"]]>>attach:sort data table.jpg]] (* is mandatory) == **Properties** == **Input** * **Data Table (DataTable

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

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

Data Table

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

" %) ((( 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

to organize and structure your code better. Eg: Generate Data Table Output Output Data Table (DataTable) - The Data Table variable that contains the generated table. Table Options Auto Detect Types (Checkbox

unstructured data to convert into a table. Only String are supported. Eg: “John | Frank | Levi” Positions

Generate Data Table

generate data table.jpg

Data Table

Generate Data Table

Data Table **Output** * **Output Data Table (DataTable)** - The Data Table variable that contains

(String)*** - The field that you add unstructured data to convert into a table. Only String are supported

. This activity enables you to select column and row separators according to which the table is generated

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

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

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

in the SQL parameter. ・TableDirect - Invokes all records from a table. Output Data Table (DataTable

Configure Connection - Set connection string, data source, data provider. Edit Query - SQL command

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

in the SQL parameter. ・TableDirect - Invokes all records from a table. **Output** * **Data Table (DataTable

connection string, data source, data provider. [[image:https://docs.akabot.com/bin/download/Activities

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