Search: join-data-table

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

Join Data Tables

join data table.jpg

Join Data Table

Data Table

"]]>>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

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.

Clear Data Table

clear data table.jpg

Data Table

Clear Data Table

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

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.

Build Data Table

build data table.jpg

Data Table

Build Data Table

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

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

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

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

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

Data Table

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

. Only string variables and strings are supported. Data Table - The data that you want to write

to start writing data. Only string variables and strings are supported. Data Table (DataTable)* - The data

RCA.Activities.Excel.WriteRange Description This activity allows you to write the data from

and strings are supported. * **Data Table** - The data that you want to write to the specified range

which to start writing data. Only string variables and strings are supported. * **Data Table (DataTable

" %) ((( RCA.Activities.Excel.WriteRange == **Description** == This activity allows you to write the data from a DataTable variable

are supported. E.g: “ClientNames” Data Table - The data to be added. This field supports only DataTable

in with "Sheet1". Only String variables and strings are supported. E.g: “ClientNames” Data Table (Datatable) * - The data to be added. This field supports only DataTable variables. Misc Public (Checkbox) - Check if you

". Only String variables and strings are supported. E.g: “ClientNames” * **Data Table** - The data

and strings are supported. E.g: “ClientNames” * **Data Table (Datatable) *** - The data to be added

to public it. Remember to consider data security requirement before using it. * **Display Name (String

. E.g: “A10” Data Table - The data that you want to write to the specified range, as a DataTable variable. Only DataTable variables are supported. Properties Input Data Table (DataTable)* - The data

RCA.Activities.Excel.ExcelWriteRange Description This activity allows you to write the data from

and strings are supported. E.g: “A10” * **Data Table** - The data that you want to write to the specified

** * **Data Table (DataTable)*** - The data that you want to write to the specified range, as a DataTable

" %) ((( RCA.Activities.Excel.ExcelWriteRange == **Description** == This activity allows you to write the data from a DataTable variable

to insert image to. E.g: “Employee Data” Range (String)* - The range you want to add image to. E.g: “K1:L1” Misc Public (Checkbox) - Check if you want to public it. Remember to consider data security

position of the image. You can edit the margin of the picture. E.g: 10 Table of Content

want to insert image to. E.g: “Employee Data” * **Range (String)* **- The range you want to add image

data security requirement before using it. * **Display Name (String)** - The name of this activity. You

the margin of the picture. E.g: 10 ))) (% class="akb-toc" %) ((( (% class="akb-toc-title" %) ((( Table