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
Last author
- 87Nga Nguyen
- 55Tuan Nguyen
- 43VuNH54
- 37Nhan Nguyen
- 28DatPT
- … 2 more
Creator
- 174admin
- 38Tuan Nguyen
- 35Nga Nguyen
- 23Giang Tran
- 7DatPT
- … 1 more
Last modification date
Creation date
Object type
Uploaded by
- 140Nga Nguyen
- 61Nhan Nguyen
- 38Tuan Nguyen
- 23Giang Tran
- 20admin
- … 2 more
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
Excel Insert Columns Table
Located in
- Rendered document content
must be made. E.g: "Sheet1" Table name (String) - Table name you want to insert. E.g: "Table1" Misc
…position in the table. (* for mandatory) In the body of activity Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Table name (String) - Table name you
- Title
Excel Insert Columns Table
- Location
Excel Insert Columns Table
- Raw document content
)** - Table name you want to insert. E.g: "Table1" * **Column name (String)** - Name of column you want
…name (String)** - Table name you want to insert. E.g: "Table1" **Misc** * **Public (Boolean
…to organize and structure your code better. E.g: [028225900] Excel Insert Columns Table ))) {{velocity
Build Data Table
Located in
- Rendered document content
RCA.Activities.Core.BuildDataTable Description This activity allows you to create a new Data Table with different settings. In the body of activity Data Table - Click to add/ remove columns
…Table Output Data Table (DataTable) - The Data Table variable that contains the generated table.
- Title
Build Data Table
- Attachment name
build data table.jpg
- Location
Data Table
…Build Data Table
- Raw document content
" %) ((( RCA.Activities.Core.BuildDataTable == **Description** == This activity allows you to create a new Data Table with different
…]] == **In the body of activity** == **Data Table **- Click to add/ remove columns, update column name/ column type
…to organize and structure your code better. **Eg**: Build Data Table **Output** * **Data Table (DataTable
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
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
Excel Insert Or Delete Columns
Located in
- Rendered document content
) - The number of columns you wish to add or remove. E.g: 1 Position (Int32) - The column where the insertion
…to add or remove. E.g: 1 Position (Int32) - The column where the insertion or removal begins. E.g: 2
…if you want to public the activity. Remember to consider data security requirement before using
- Title
Excel Insert Or Delete Columns
- Location
Excel Insert Or Delete Columns
- Raw document content
)** - The column where the insertion or removal begins. E.g: 2 * **Sheet name (String)*** - The name of the sheet
…)** - The column where the insertion or removal begins. E.g: 2 **Input** * **Change Mode (Dropdown List
…to public the activity. Remember to consider data security requirement before using this property
Excel Insert Or Delete Rows
Located in
- Rendered document content
) - The number of rows you wish to add or remove. E.g: 1 Position (Int32) - The row where the insertion
…) - The number of rows you wish to add or remove. E.g: 1 Row Position (Int32) - The row where the insertion
…: "Sheet1" Misc Public (Boolean) - Check if you want to public the activity. Remember to consider data
- Title
Excel Insert Or Delete Rows
- Location
Excel Insert Or Delete Rows
- Raw document content
)** - The row where the insertion or removal begins. By default, this is filled in with 1. E.g: 2 * **Sheet
…or remove. E.g: 1 * **Row Position (Int32)** - The row where the insertion or removal begins. By default
…. Remember to consider data security requirement before using this property. * **Display Name (String
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