Search: insert-data-table
Last modified by admin on 2022/04/24 04:58
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
Clear Data Table
Located in
- Rendered document content
DataTable. (* is mandatory) Properties Input Data Table(DataTable)* - The data table that you want to clear the data. Misc Public (Checkbox) - Check if you want to publicize it. Remember to consider data
…the name of the activity to organize and structure your code better. Eg: Clear Data Table.
- Title
Clear Data Table
- Attachment name
clear data table.jpg
- Location
Data Table
…Clear Data Table
- Raw document content
data table.jpg]]>>attach:clear data table.jpg]] (* is mandatory) == **Properties** == **Input** * **Data Table(DataTable)*** - The data table that you want to clear the data. **Misc** * **Public
…to organize and structure your code better. **Eg**: Clear Data Table. ))) {{velocity}} #if ($xcontext.action
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
Excel Insert Image
Located in
- Rendered document content
to insert image to. E.g: “Employee Data” Range (String)* - The range you want to add image to. E.g: “K1:L1
…file you want to insert. This field accepts only strings and String variables. E.g: “C:\FolderName
…path of the image or click “…” button to choose file you want to insert. This field accepts only
- Title
Excel Insert Image
- Location
Excel Insert Image
- Raw document content
want to insert image to. E.g: “Employee Data” * **Range (String)* **- The range you want to add image
…(String)** - Input the full path of the image or click “…” button to choose file you want to insert
…path of the image or click “…” button to choose file you want to insert. This field accepts only
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
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