Search: remove-data-row

for each row in a specified DataTable variable. (* is mandatory) 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 (DataTable)* - The DataColumn object whose value is to be retrieved from

For Each Row

for each row.jpg

Data Table

For Each Row

" %) ((( RCA.Activities.Core.ForEachRow == **Description** == This activity allows you to execute an action once for each row

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

also help you return the value found in the cell that has the row specified in the RowIndex property

supports only strings and String variables. E.g: “WordIWantToSearch” Data Table (DataTable

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

the data table **Output** * **Cell Value** - Optional. The value found in the cell that has the Row

the value found in the cell that has the row specified in the RowIndex property and the column specified in the Target Column property category. [[[[image:look up data table.jpg||class="img-thumbnail

of the CSV file E.g: “C:\CSVFolder\clientList.csv” Misc 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. Display Name (String

Column Names (Checkbox)- Specifies if the first row in the CSV file should be considered a header row

” **Misc** * **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. * **Display Name (String) **- The name of this activity

” * **Include Column Names (Checkbox)**- Specifies if the first row in the CSV file should be considered

RCA.Activities.Core.RemoveLogFields Description This activity allows you to remove customized log

)* - The collection of string arguments to be removed from subsequent log lines. Misc Public (Checkbox) - If you check it, the data of this activity will be shown in the log. Be careful, consider data security before

Remove Log Fields

Remove Log Fields

" %) ((( RCA.Activities.Core.RemoveLogFields == **Description** == This activity allows you to remove customized log fields to each Log

** == **Input** * **Fields (Collection of String)*** - The collection of string arguments to be removed from subsequent log lines. **Misc** * **Public (Checkbox)** - If you check it, the data of this activity

in an Excel workbook. Can also be used to shift an entire row or column by using the ShiftCells

of the sheet contains the data you want to delete. By default, this is filled in with "Sheet1." Only String variables and strings are supported. E.g: “Employee Data” Range (String)* - The range you want to delete

. Can also be used to shift an entire row or column by using the ShiftCells and ShiftOption property

** == **Input** * **Sheet Name (String)** - The name of the sheet contains the data you want to delete

Data” * **Range (String)* **- The range you want to delete. This field supports only strings

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

it. Remember to consider data security requirements before using it. Display Name (String) - The name

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 settings. [[[[image:build data table.jpg||class="img-thumbnail"]]>>attach:build data table.jpg]] == **In the body of activity** == **Data Table **- Click to add/ remove columns, update column name/ column type