Search: join-data-table
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Location
- 89Activities
- 2akaBot Vision
Last author
- 57Nhan Nguyen
- 31VuNH54
- 2admin
- 1DatPT
Last modification date
Creation date
Upload date
Create New Pipeline
Located in
- Rendered document content
at: [email protected] for more assistant. Step 4: Choose one or more users to join this pipeline for reviewing documents (if need). Step 5: Click "OK" button to complete creating a new pipeline. Table
- Raw document content
:1704877579310-775.png||height="377" width="566"]] **Step 4**: Choose one or more users to join this pipeline
…" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) )))
Remove Duplicated Rows
Located in
- Rendered document content
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.
- Location
Data Table
- Raw document content
" %) ((( 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
Get Table
Located in
- Rendered document content
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
- Title
Get Table
- Location
Get Table
- Raw document content
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
For Each Row
Located in
- Rendered document content
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
- Location
Data Table
- Raw document content
) == **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
Bulk Add Queue Items
Located in
- Rendered document content
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.
- Raw document content
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
Add Data Column
Located in
- Rendered document content
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
- Title
Add Data Column
- Attachment name
add data column.jpg
- Location
Data Table
…Add Data Column
- Raw document content
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
Remove Data Row
Located in
- Rendered document content
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
- Title
Remove Data Row
- Attachment name
remove data row.jpg
- Location
Data Table
…Remove Data Row
- Raw document content
" %) ((( 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
Add Data Row
Located in
- Rendered document content
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
- Title
Add Data Row
- Attachment name
add data row.jpg
- Location
Data Table
…Add Data Row
- Raw document content
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
Remove Data Column
Located in
- Rendered document content
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
- Title
Remove Data Column
- Attachment name
remove data column.jpg
- Location
Data Table
…Remove Data Column
- Raw document content
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
Execute Query
Located in
- Rendered document content
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
- Raw document content
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