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
- 221Activities
- 12akaBot Center
- 10akaBot Vision
- 4akaBot Insights
- 3Data Service
- … 3 more
Last author
- 65Nga Nguyen
- 58Nhan Nguyen
- 44admin
- 38Tuan Nguyen
- 33VuNH54
- … 3 more
Last modification date
Creation date
Object type
Uploaded by
- 106Nga Nguyen
- 91Nhan Nguyen
- 37admin
- 9Giang Tran
- 5VuNH54
- … 2 more
Upload date
Insert Data Table
Located in
- Rendered document content
and descriptions must match the ones from the database table. Table Name - The SQL table in which the data
…to access the database. E.g: “System.Data.SqlClient” Input Data Table (DataTable)* - The DataTable
…the ones from the database table. Table Name (String)*- The SQL table in which the data is to be inserted
- Title
Insert Data Table
- Location
Insert Data Table
- Raw document content
and descriptions must match the ones from the database table. * **Table Name **- The SQL table in which the data
…” **Input** * **Data Table (DataTable)*** - The DataTable variable that will be inserted into the Table
…(String)***- The SQL table in which the data is to be inserted. E.g: “TargetedTable” **Misc** * **Public
Look Up Data Table
Located in
- Rendered document content
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
- Title
Look Up Data Table
- Attachment name
look up data table.jpg
- Location
Data Table
…Look Up Data Table
- Raw document content
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
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
[2] Add New Field for Model
Located in
- Rendered document content
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
- Raw document content
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
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
[4] Business
Located in
- Rendered document content
based upon the value entered in the ROI data set table, as well as the days until your defined goal
…the Manual Time value entered in the ROI data set table. Goal Input Static display of your defined
…to date, based upon the Manual Time value entered in the ROI data set table. Displays the Top 10
- Raw document content
value entered in the **ROI data set table**. ))) |((( **Goal ** )))|((( Input )))|((( Static display
…in the **ROI data set table**. ))) |((( **Cumulative Time Saved** )))|((( Column Chart )))|((( Total time saved
…** )))|((( Input )))|((( Displays the current total of money saved based upon the value entered in the **ROI data
[6] Customize Data Extract
Located in
- Rendered document content
Automation of Fields Capture Custom Table Data Configure Automation Type for Pipeline Configure Fields for Data Extraction
- Title
[6] Customize Data Extract
- Location
Customizing Data Extract
- Raw document content
* [[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
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
Activities
Located in
- Rendered document content
Database Connect Database Disconnect Database Transaction Execute Non Query Execute Query Insert Data Table
- Raw document content
/view/Activities/Database/Activities/Execute%20Query/]] * [[Insert Data Table>>url:https