Search: join-data-table

. (* is mandatory) Properties Input Destination (DataTable)* - The data table that takes the data from the source data table and handles the changes and missing schema. Source (DataTable)*- The data table to be merged with the destination data table. Misc Public (Checkbox) - Check if you want to publicize

Merge Data Table

merge data table.jpg

Data Table

Merge Data Table

** == **Input** * **Destination (DataTable)*** - The data table that takes the data from the source data table and handles the changes and missing schema. * **Source (DataTable)***- The data table to be merged with the destination data table. **Misc** * **Public (Checkbox)** - Check if you want

RCA.Activties.Core.OutputDataTable Description This activity allows you to write a Data Table to a string using the CSV format. (* is mandatory) Properties Input Data Table (DataTable)* - The data

can edit the name of the activity to organize and structure your code better. Eg: Output data table

Output Data Table

ouput data table.jpg

Data Table

Output Data Table

" %) ((( RCA.Activties.Core.OutputDataTable == **Description** == This activity allows you to write a Data Table to a string using

** * **Data Table (DataTable)*** - The data table that you want to output. **Misc** * **Public (Checkbox

and structure your code better. **Eg**: Output data table **Output** * **Text **- The output of the Data

RCA.Activities.Core.SortDataTables Description This activity allows you to sort data tables

Input Data Table (DataTable)* - The data table variable you want to sort. This field supports only

the name of the activity to organize and structure your code better. Eg: Sort Data table Output Output

Sort Data Table

sort data table.jpg

Data Table

Sort Data Table

" %) ((( RCA.Activities.Core.SortDataTables == **Description** == This activity allows you to sort data tables in ascending or descending

"]]>>attach:sort data table.jpg]] (* is mandatory) == **Properties** == **Input** * **Data Table (DataTable)* **- The data table variable you want to sort. This field supports only DataTable variables **Misc

unstructured data to convert into a table. Only String are supported. Eg: “John | Frank | Levi” Positions

to organize and structure your code better. Eg: Generate Data Table Output Output Data Table (DataTable) - The Data Table variable that contains the generated table. Table Options Auto Detect Types (Checkbox

Generate Data Table

generate data table.jpg

Data Table

Generate Data Table

(String)*** - The field that you add unstructured data to convert into a table. Only String are supported

Data Table **Output** * **Output Data Table (DataTable)** - The Data Table variable that contains

. This activity enables you to select column and row separators according to which the table is generated

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

duplicate rows in the data table. (* is mandatory) Properties Input Data Table (DataTable)* - The data table you want to check. Misc Public (Checkbox) - Check if you want to publicize it. Remember

Rows. Output Output Data Table(DataTable) - The column value from the specified DataRow.

Data Table

" %) ((( RCA.Activities.Core.RemoveDuplicatedRows == **Description** == This activity allows you to remove duplicate rows in the data table

** == **Input** * **Data Table (DataTable)* **- The data table you want to check. **Misc** * **Public

** * **Output Data Table(DataTable) **- The column value from the specified DataRow. ))) {{velocity

of activity File path (String) - You can add the file path of the CSV here. String supported only. Data Table (DataTable) - The data table you want to append. Properties File File Path (String)* - The file path of the CSV file E.g: “C:\CSVFolder\clientList.csv” Input Data Table (DataTable)* - Specifies the DataTable

of the CSV here. String supported only. * **Data Table (DataTable)** - The data table you want to append

\clientList.csv” **Input** * **Data Table (DataTable)*** - Specifies the DataTable to be appended to the CSV

)** - If you check it, the data of this activity will be shown in the log. Be careful, consider data security

the file path of the CSV here. String supported only. Data Table (DataTable) - Specifies the DataTable to be written in the CSV file. Properties Input Data Table (DataTable)* - Specifies the DataTable

\clientList.csv” Misc Public (CheckBox) - If you check it, the data of this activity will be shown in the log

** == * **File Path (String)** - You can add the file path of the CSV here. String supported only. * **Data Table (DataTable)** - Specifies the DataTable to be written in the CSV file. == **Properties** == **Input** * **Data Table (DataTable)*** - Specifies the DataTable to be written in the CSV file

(DataTable) - Stores the data extracted from the specified Excel range in a data table variable. Only data

” Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Range - Range of the data. If it isn’t

)- The sheet you want to read. E.g: "Sheet1" Range - Range of the data. If it isn’t specified, the whole

range in a data table variable. Only data table variables are supported ))) {{velocity

: "Sheet1" * **Range** - Range of the data. If it isn’t specified, the whole spreadsheet will be read. E.g

want to read. E.g: "Sheet1" * **Range** - Range of the data. If it isn’t specified, the whole

want to add to the specified DataTable Object. String supported only. Data Table (DataTable

Public (Checkbox) - Check if you want to publicize it. Remember to consider data security requirements

to organize and structure your code better. Eg: Add Data Column Type Argument (Type) - A reference type

Add Data Column

add data column.jpg

Data Table

Add Data Column

to the specified DataTable Object. String supported only. * **Data Table (DataTable)*** - The DataTable object

DataTable. [[image:add data column.jpg||class="img-thumbnail"]] (* is mandatory) == **Properties

(Checkbox)** - Check if you want to publicize it. Remember to consider data security requirements before