Search: add-data-column
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Location
- 52Activities
- 1Sandbox
- 1akaBot Vision
Last author
- 19Nhan Nguyen
- 11VuNH54
- 8Giang Tran
- 7admin
- 5DatPT
- … 1 more
Creator
- 25admin
- 17Giang Tran
- 9Tuan Nguyen
- 3Nhan Nguyen
Last modification date
Creation date
Object type
Upload date
Add Data Column
Located in
- Rendered document content
to organize and structure your code better. Eg: Add Data Column Type Argument (Type) - A reference type
…want to add to the specified DataTable Object. String supported only. Data Table (DataTable)* - The DataTable object in which you want to add a column. This field supports only DataTable objects. Misc
- Title
Add Data Column
- Attachment name
add data column.jpg
- Location
Add Data Column
…Data Table
- Raw document content
of the activity to organize and structure your code better. **Eg**: Add Data Column * **Type Argument (Type
…collection of the DataTable. * **Column Name (String)*** - The name of the new column you want to add
…in which you want to add a column. This field supports only DataTable objects. **Misc** * **Public
Build Data Table
Located in
- Rendered document content
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, update column name/ column type Properties Misc Public (Checkbox) - Check if you want to publicize
- Title
Build Data Table
- Attachment name
build data table.jpg
- Location
Data Table
…Build Data Table
- Raw document content
" %) ((( 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
Add Data Row
Located in
- Rendered document content
RCA.Activities.Core.AddDataRow Description This activity allows you to add a Data Row
…, then the ArrayRow property is ignored. Data Table (DataTable)* - The DataTable object in which you want to add
…. Eg: Add Data Row
- Title
Add Data Row
- Attachment name
add data row.jpg
- Location
Add Data Row
…Data Table
- Raw document content
is ignored. * **Data Table (DataTable)*** - The DataTable object in which you want to add a column
…" %) ((( RCA.Activities.Core.AddDataRow == **Description** == This activity allows you to add a Data Row to a specified DataTable
…should map to the type of its corresponding column in the DataTable. * **Data row (DataRow
Remove Data Column
Located in
- Rendered document content
is ignored. Eg: “Phone Number”. Data table (DataTable)* - The DataTable object from which the column
…of the activity to organize and structure your code better. Eg: “Remove Data Column”
…RCA.Activities.Core.RemoveDataColumn Description This activity allows you to remove a Data
- Title
Remove Data Column
- Attachment name
remove data column.jpg
- Location
Remove Data Column
…Data Table
- Raw document content
" %) ((( RCA.Activities.Core.RemoveDataColumn == **Description** == This activity allows you to remove a Data Column to a specified
…Number”. * **Data table (DataTable)*** - The DataTable object from which the column is to be removed
…edit the name of the activity to organize and structure your code better. Eg: “Remove Data Column
Generate Data Table
Located in
- Rendered document content
the structured text. This activity enables you to select column and row separators according to which the table
…(default) - blocks the process from continuing the execution. Fixed formatting options Column Sizes (IEnumerable< Int32 >) - Specifies the size of the columns that are to be created in the table. This field
- Title
Generate Data Table
- Attachment name
generate data table.jpg
- Location
Data Table
…Generate Data Table
- Raw document content
(String)*** - The field that you add unstructured data to convert into a table. Only String are supported
…. This activity enables you to select column and row separators according to which the table is generated. [[[[image:generate data table.jpg||class="img-thumbnail"]]>>attach:generate data table.jpg]] (* is mandatory
Read CSV File
Located in
- Rendered document content
a specified CSV File. (* is mandatory) In the body of activity File Path (String) - You can add the file
…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
- Raw document content
Path (String)** - You can add the file path of the CSV here. String supported only. == **Properties
…” **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
Write CSV File
Located in
- Rendered document content
DataTable to a CSV File. (* is mandatory) In the body of activity 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
- Raw document content
** == * **File Path (String)** - You can add the file path of the CSV here. String supported only. * **Data
…” * **Add Headers (CheckBox)** - Boolean that specifies if the column names from the DataTable will be added
…** == **Input** * **Data Table (DataTable)*** - Specifies the DataTable to be written in the CSV file
Look Up Data Table
Located in
- Rendered document content
for. This field supports only strings and String variables. Eg: “Name of column” Data Column (DataColumn
…and String variables. Eg: “Name of targeted column” Data Column (DataColumn) - Specifying a DataColumn
…and the column specified in the Target Column property category. (* is mandatory) Properties Input Lookup
- Title
Look Up Data Table
- Attachment name
look up data table.jpg
- Location
Data Table
…Look Up Data Table
- Raw document content
in the Target Column property category. [[[[image:look up data table.jpg||class="img-thumbnail
…to search for. This field supports only strings and String variables. Eg: “Name of column” * **Data Column
…. Eg: “Name of targeted column” * **Data Column (DataColumn)** - Specifying a DataColumn variable here
Sort Data Table
Located in
- Rendered document content
: “Column name here”. Data Column (DataColumn) - The variable containing the column you want to sort
…RCA.Activities.Core.SortDataTables Description This activity allows you to sort data tables in ascending or descending order, based on the values of a specified column. (* is mandatory) Properties
- Title
Sort Data Table
- Attachment name
sort data table.jpg
- Location
Data Table
…Sort Data Table
- Raw document content
" %) ((( RCA.Activities.Core.SortDataTables == **Description** == This activity allows you to sort data tables in ascending or descending order, based on the values of a specified column. [[[[image:sort data table.jpg||class="img-thumbnail
…: “Column name here”. * **Data Column (DataColumn)** - The variable containing the column you want to sort
Get Row Item
Located in
- Rendered document content
a DataRow variable according to a specified column. (* is mandatory) In the body of activity DataTable row (DataRow)* - The DataRow object from which a value is to be retrieved. Properties Input Column
…, the ColumnName and ColumnIndex properties are ignored. Column Index (Int)* - The index of the column whose value
- Location
Data Table
- Raw document content
according to a specified column. [[[[image:get row item.jpg]]>>attach:get row item.jpg
…a value is to be retrieved. == **Properties** == **Input** * **Column (DataColumn
…and ColumnIndex properties are ignored. * **Column Index (Int)*** - The index of the column whose value