Search: insert-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
- 65Activities
- 8akaBot Vision
Last author
- 39Nhan Nguyen
- 24VuNH54
- 8admin
- 1DatPT
- 1Giang Tran
Creator
- 64admin
- 8Nhan Nguyen
- 1Giang Tran
Last modification date
Creation date
Object type
Upload date
Insert Data Table
Located in
- Rendered document content
the ones from the database table. Table Name (String)*- The SQL table in which the data is to be inserted
…can edit the name of the activity to organize and structure your code better. Eg: Insert Data Table
…Table - The DataTable variable that will be inserted into the Table. The DataTable columns' names
- Title
Insert Data Table
- Location
Insert Data Table
- Raw document content
” **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
…to organize and structure your code better. Eg: Insert Data Table **Output** * **Affected Records (Int32
Join Data Tables
Located in
- Rendered document content
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
…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
Data Table
…Join Data Table
- Raw document content
" %) ((( 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
…** * **Data Table1 (DataTable)*** - The first table that you want to use in the Join operation, is stored
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
[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
[3] Review Document
Located in
- Rendered document content
, akaBot Vision provides users with the capability to add or remove rows in a table To insert a row, you can click "+" icon To delete a row, you can click "x" icon To add a new row at the end of the table
…After importing the document successfully and the data extraction process is successfully finished
- Raw document content
or remove rows in a table * To insert a row, you can click "+" icon * To delete a row, you can click "x
…="wikigeneratedid" %) After importing the document successfully and the data extraction process is successfully
…with this status in the “To review” tab in the user interface. [[image:image-20220420193327-1.png||data-xwiki
Execute Non Query
Located in
- Rendered document content
statement on a database. For UPDATE, INSERT, and DELETE statements, the return value is the number of rows
…) In the body of activity Configure Connection - Set connection string, data source, data provider. Edit
…if you want to publicize it. Remember to consider data security requirements before using it. Display
- Raw document content
. For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command
…]] (* for Mandatory) == **In the body of activity** == * **Configure Connection **- Set connection string, data source, data provider. [[image:https://docs.akabot.com/bin/download/Activities/Database/Activities
Open Browser
Located in
- Rendered document content
it. (* for Mandatory) In the body of activity URL (String) - Insert a specified URL in the container. Ex: “https
…(Browser)* - Insert the specified browser in which activities could be active. URL (String)* - Provide
…want to publicize it. Remember to consider data security requirements before using it. Display Name
- Raw document content
-20220506110901-1.png]] (* for Mandatory) **In the body of activity** * **URL (String)** - Insert
…Browser (Browser)*** - Insert the specified browser in which activities could be active. * **URL (String
…to consider data security requirements before using it. * **Display Name (String)** - The name
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
Word Application Scope
Located in
- Rendered document content
does not exist, a new document file is created. Misc 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. Display Name (String
…. E.g: Working with Word. Option Password (String) - Insert Word file password to proceed. String
- Raw document content
** * **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. * **Display Name (String)** - The name of this activity. You can
…. **Option** * **Password (String) **- Insert Word file password to proceed. String variables and Strings
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