Search: join-data-table

Automation of Fields Capture Custom Table Data Configure Automation Type for Pipeline Configure Fields for Data Extraction

[6] Customize Data Extract

Customizing Data Extract

* [[Automation of Fields>>path:/bin/view/akaBot%20Vision/Customizing%20Data%20Extract/Automation%20of%20Fields%20in%20akaBot%20Vision/]] * [[Capture Custom Table Data>>path:/bin/view/akaBot%20Vision

/Configure%20Automation%20Type%20for%20Pipeline%20/]] * [[Configure Fields for Data Extraction>>path:/bin

loop variable name in - Data table to loop Body - Add activities that you want to execute in loop Properties Input Data Table (DataTable)* - The DataColumn object whose value is to be retrieved from the DataRow. Misc Public (Checkbox) - Check if you want to publicize it. Remember to consider data security

Data Table

) == **In the body of activity** == **Foreach** - Set loop variable name **in** - Data table to loop **Body **- Add activities that you want to execute in loop == **Properties** == **Input** * **Data Table

(Checkbox)** - Check if you want to publicize it. Remember to consider data security requirements before

Database Connect Database Disconnect Database Transaction Execute Non Query Execute Query Insert Data Table

/view/Activities/Database/Activities/Execute%20Query/]] * [[Insert Data Table>>url:https

to add a collection of items to a data table to a specific queue. Once it is added to the queue

) - The data table that you want to add the queue into. QueueName (String) - The queue to which the new queue

Output Result (DataTable) - This is the data table that you have added to the queue.

of items to a data table to a specific queue. Once it is added to the queue, the items’ status is changed

. The default value is: AllOrNothing * **Queue Items DataTable (DataTable)** - The data table that you want

**Output** * **Result (DataTable) **- This is the data table that you have added to the queue

want to add to the specified DataTable Object. String supported only. Data Table (DataTable

Public (Checkbox) - Check if you want to publicize it. Remember to consider data security requirements

to organize and structure your code better. Eg: Add Data Column Type Argument (Type) - A reference type

Add Data Column

add data column.jpg

Data Table

Add Data Column

to the specified DataTable Object. String supported only. * **Data Table (DataTable)*** - The DataTable object

DataTable. [[image:add data column.jpg||class="img-thumbnail"]] (* is mandatory) == **Properties

(Checkbox)** - Check if you want to publicize it. Remember to consider data security requirements before

RCA.Activities.Core.RemoveDataRow Description This activity allows you to remove a Data Row to a specified DataTable. (* is mandatory) Properties Input Data Row (DataRow)* - The DataRow object which is to be removed. Data Table (DataTable)* - The DataTable object from which the row is removed. Row Index (Int

Remove Data Row

remove data row.jpg

Data Table

Remove Data Row

" %) ((( RCA.Activities.Core.RemoveDataRow == **Description** == This activity allows you to remove a Data Row to a specified DataTable. [[image:remove data row.jpg]] (* is mandatory) == **Properties** == **Input** * **Data Row (DataRow)*** - The DataRow object which is to be removed. * **Data Table (DataTable

in edit mode. Select Data Source. Search jhi_dataset table and drag it to the data source interface. Select a relationship with an existing table on the data source interface.

Dataset The default columns in the Business Dataset table are Manual Time and Hourly Cost. You can also

[1] ROI data set

in edit mode. 1. Select **Data Source**. 1. Search **jhi_dataset **table and drag it to the data source interface. 1. Select a relationship with an existing table on the data source interface. ))) {{velocity

** == The default columns in the **Business Dataset** table are **Manual Time** and **Hourly Cost**. You can also

in the DataTable. Data row (DataRow) - The DataRow object to be added to the DataTable. If this property is set, then the ArrayRow property is ignored. Data Table (DataTable)* - The DataTable object in which you want to add

RCA.Activities.Core.AddDataRow Description This activity allows you to add a Data Row

Add Data Row

add data row.jpg

Data Table

Add Data Row

is ignored. * **Data Table (DataTable)*** - The DataTable object in which you want to add a column

" %) ((( RCA.Activities.Core.AddDataRow == **Description** == This activity allows you to add a Data Row to a specified DataTable. [[[[image:add data row.jpg]]>>attach:add data row.jpg]] (* is mandatory) == **Properties** == **Input

/bin/view/Activities/Data%20Table/Activities/Join%20Data%20Table/]] * [[データテーブルを検索>>url:https://docs

* [[データ列を追加>>url:https://docs.akabot.com/bin/view/Activities/Data%20Table/Activities/Add%20Data%20Column/]] * [[データ行を追加>>url:https://docs.akabot.com/bin/view/Activities/Data%20Table/Activities/Add%20Data

Data Table

is ignored. Eg: “Phone Number”. Data table (DataTable)* - The DataTable object from which the column is to be removed. Misc Public (Checkbox) - Check if you want to publicize it. Remember to consider data security

RCA.Activities.Core.RemoveDataColumn Description This activity allows you to remove a Data

Remove Data Column

remove data column.jpg

Data Table

Remove Data Column

Number”. * **Data table (DataTable)*** - The DataTable object from which the column is to be removed

" %) ((( RCA.Activities.Core.RemoveDataColumn == **Description** == This activity allows you to remove a Data Column to a specified DataTable. [[[[image:remove data column.jpg]]>>attach:remove data column.jpg]] (* is mandatory