Search: insert-data-table

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

Join Data Tables

join data table.jpg

Data Table

Join Data Table

" %) ((( 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

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

Filter Data Table

filter data table.jpg

Data Table

.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

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

Look Up Data Table

look up data table.jpg

Data Table

Look Up Data Table

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

to insert one or more rows in a table, range, or sheet at the specified location. This only can be used

(String)* - The name of the sheet that you want to insert row. E.g: “Employee Name” Number of row (Int) - Number of rows you want to insert in Excel sheet E.g: 5 Row position (Int) - Position where the rows

Excel Insert Rows

Excel Insert Rows

" %) ((( RCA.Activities.Excel.ExcelInsertRows == **Description** == This activity allows you to add more rows to insert one or more rows in a table, range, or sheet at the specified location. This only can be used in Excel Application Scope

of the activity** == * **Sheet name (String)*** - The name of the sheet that you want to insert row. E.g

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

Excel Insert Image

Excel Insert Image

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

Append Range Excel Append Range Excel Application Scope Excel Close Workbook Excel Copy Paste Range Excel Copy Sheet Excel Delete Range Excel Get Workbook Sheet Excel Get Workbook Sheets Excel Insert Columns Table Excel Insert Or Delete Columns Excel Insert Or Delete Rows Excel Insert Rows Excel

/Activities/Excel%20Activities/Activities/Excel%20Get%20Workbook%20Sheets/]] * [[Excel Insert Columns Table

%20Table/]] * [[Excel Insert Or Delete Columns>>url:https://docs.akabot.com/bin/view/Activities/Excel

Insert Or Delete Rows>>url:https://docs.akabot.com/bin/view/Activities/Excel%20Activities/Activities

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

. 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

) - 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

Excel Insert Or Delete Columns

Excel Insert Or Delete Columns

)** - 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

) - 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

Excel Insert Or Delete Rows

Excel Insert Or Delete Rows

)** - 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

in the .csv file that contains the job data. By default, this property is set to COMMA. The following options

in the .csv file that contains job data. File Path – The full path to the .csv file that contains the job data. Only String variables supported. Line Ending - Specifies the line ending which marks the end of a data

for columns in the .csv file that contains the job data. By default, this property is set to **COMMA

operations. The field values must also be found in the .csv file that contains job data. * **File Path **– The full path to the .csv file that contains the job data. Only String variables supported. * **Line Ending