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
- 239Activities
- 16akaBot Vision
- 8akaBot Center
- 3akaBot Insights
- 2Data Service
- … 4 more
Last author
- 60Tuan Nguyen
- 55Nga Nguyen
- 47VuNH54
- 45admin
- 39Nhan Nguyen
- … 3 more
Creator
- 177admin
- 42Tuan Nguyen
- 26Nga Nguyen
- 19Giang Tran
- 8Nhan Nguyen
- … 1 more
Last modification date
Creation date
Object type
- 2Activities
- 1Overview
- 1aka Bot Vision
Upload date
Join Data Tables
Located in
- Rendered document content
Join Table Wizard - set join condition and join type Properties Input Data Table1 (DataTable)* - The first table that you want to use in the Join operation, is stored in a DataTable variable. This field
…to organize and structure your code better. Eg: Join Data Table\ Option Join Type (JoinType) - INNER/LEFT
- Title
Join Data Tables
- Attachment name
join data table.jpg
- Location
Join Data Table
…Data Table
- Raw document content
"]]>>attach:join data table.jpg]] (* is mandatory) == **In the body of activity** == **Join Table Wizard - **set
…** * **Data Table1 (DataTable)*** - The first table that you want to use in the Join operation, is stored
…Table\ **Option** * **Join Type (JoinType)** - INNER/LEFT/FULL. **Output** * **Output Data Table
Filter Data Table
Located in
- Rendered document content
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
- Title
Filter Data Table
- Attachment name
filter data table.jpg
- Location
Data Table
- Raw document content
.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
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
[4] Capture Custom Table Data
Located in
- Rendered document content
. Adding a new table In order to create a new table, click [Add Field], select Data Type = “table
…A basic element in the extraction schema is the data field. However, akaBot Vision enables the capture of even more complex structures like tables. Adding a predefined table field If you are missing
- Title
[4] Capture Custom Table Data
- Location
Capturing Custom Table Data in akaBot Vision
…Customizing Data Extract
- Raw document content
, click [Add Field], select Data Type = “table” and then input the value you want to create a new table
…="wikigeneratedid" id="HParagraph1" %) A basic element in the extraction schema is the data field. However, akaBot Vision enables the capture of even more complex structures like tables. == **Adding a predefined table
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"/}} ))) )))
[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
Excel Append Range
Located in
- Rendered document content
in a Data Table variable to the end of a specified Excel spreadsheet. (* is mandatory) In the body
…, this is filled in with "Sheet1". Only String variables and strings are supported. E.g: “ClientNames” Data Table
…." Only String variables and strings are supported. E.g: “ClientNames” Data Table (DataTable)* - The data
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelAppendRange == **Description** == This activity allows adding information stored in a Data Table variable
…: “ClientNames” * **Data Table** - The data to be added. This field supports only DataTable variables
…: “ClientNames” * **Data Table (DataTable)*** - The data to be added. This field supports only DataTable
[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