Search: clear-data-table

the name of the activity to organize and structure your code better. Eg: Clear 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

Clear Data Table

clear data table.jpg

Clear Data Table

Data Table

** * **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.ClearDataTable == **Description** == This activity allows you to clear a specified DataTable. [[[[image:clear

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

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

and descriptions must match the ones from the database table. Table Name - The SQL table in which the data

to access the database. E.g: “System.Data.SqlClient” Input Data Table (DataTable)* - The DataTable

the ones from the database table. Table Name (String)*- The SQL table in which the data is to be inserted

Insert Data Table

Insert Data Table

and descriptions must match the ones from the database table. * **Table Name **- The SQL table in which the data

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

. Auto Fill Range: Fulfills the auto-fill functionality from the Google Sheets user interface. Clear Range: Uses the Microsoft Graph Clear range API to clear values, format, fill, border, etc. of a range

the Microsoft Graph Clear range (when Shift is None) or Delete range (when Shift is Up or Left) API to delete

functionality from the Google Sheets user interface. * Clear Range: Uses the Microsoft Graph Clear range API to clear values, format, fill, border, etc. of a range from the specified sheet * Copy Paste Range: Copies

to the source file. * Delete Range: Uses the Microsoft Graph Clear range (when **Shift** is //None//) or Delete

RCA.Activities.Excel.ExcelReadColumn Description Read all data into column has determined

 - The cell from which to start extracting the column data. By default, this is filled in with "A1". E.g: "A1

)* - The cell from which to start extracting the column data. By default, this is filled in with "A1". E.g: "A1

RCA.Activities.Excel.ExcelReadColumn == **Description** == Read all data into column has

to start extracting the column data. By default, this is filled in with "A1". E.g**:** "A1

" * **Starting Cell (String)*** - The cell from which to start extracting the column data. By default

. E.g: "Sheet1" Starting Cell - The cell from which to start extracting the row data. By default

: "Sheet1" Starting Cell (String)* - The cell from which to start extracting the row data. By default

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

from which to start extracting the row data. By default, this is filled in with "A1". E.g: "A1

" * **Starting Cell (String)*** - The cell from which to start extracting the row data. By default

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

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

Get Table

Get Table

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

(String)* - The cell from which to start extracting the column data. By default, this is filled

" Starting Cell (String)* - The cell from which to start extracting the column data. By default

. Remember to consider data security requirement before using this property. Display Name (String) - The name

data. By default, this is filled in with "A1". E.g**:** "A1" == **Properties** == **Input

)*** - The cell from which to start extracting the column data. By default, this is filled in with "A1". E.g: "A1

to consider data security requirement before using this property. * **Display Name (String) **- The name