Search: add-data-row
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Location
- 44Activities
- 11akaBot Center
- 4Data Service
- 1App Connect
- 1Sandbox
- … 3 more
Last author
- 24admin
- 13Nhan Nguyen
- 9Giang Tran
- 9VuNH54
- 5DatPT
- … 2 more
Creator
- 37admin
- 16Giang Tran
- 8Tuan Nguyen
- 1Nga Nguyen
- 1Nhan Nguyen
- … 1 more
Last modification date
Creation date
Object type
- 2Rights
- 2aka Bot Center
- 1Activities
Uploaded by
- 25admin
- 18Nhan Nguyen
- 17Giang Tran
- 8Tuan Nguyen
- 6VuNH54
- … 2 more
Upload date
Add Data Row
Located in
- Rendered document content
RCA.Activities.Core.AddDataRow Description This activity allows you to add a Data Row
…. Eg: Add Data Row
…in the DataTable. Data row (DataRow) - The DataRow object to be added to the DataTable. If this property is set
- Title
Add Data Row
- Attachment name
add data row.jpg
- Location
Add Data Row
…Data Table
- Raw document content
" %) ((( RCA.Activities.Core.AddDataRow == **Description** == This activity allows you to add a Data Row to a specified DataTable
…. Eg: Add Data Row ))) {{velocity}} #if ($xcontext.action != 'export') (% class="akb-toc
…should map to the type of its corresponding column in the DataTable. * **Data row (DataRow
Remove Data Row
Located in
- Rendered document content
RCA.Activities.Core.RemoveDataRow Description This activity allows you to remove a Data Row to a specified DataTable. (* is mandatory) Properties Input Data Row (DataRow)* - The DataRow object which is to be removed. Data Table (DataTable)* - The DataTable object from which the row is removed. Row Index (Int
- Title
Remove Data Row
- Attachment name
remove data row.jpg
- Location
Remove Data Row
…Data Table
- Raw document content
" %) ((( RCA.Activities.Core.RemoveDataRow == **Description** == This activity allows you to remove a Data Row to a specified
…** * **Data Row (DataRow)*** - The DataRow object which is to be removed. * **Data Table (DataTable
…edit the name of the activity to organize and structure your code better. Eg: Remove data row
Add Data Column
Located in
- Rendered document content
want to add to the specified DataTable Object. String supported only. Data Table (DataTable
…to organize and structure your code better. Eg: Add Data Column Type Argument (Type) - A reference type
…RCA.Activities.Core.AddDataColumn Description This activity allows you to add a DataColumn
- 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
…" %) ((( RCA.Activities.Core.AddDataColumn == **Description** == This activity allows you to add a DataColumn to a specified DataTable. [[image:add data column.jpg||class="img-thumbnail"]] (* is mandatory) == **Properties
Excel Insert Or Delete Rows
Located in
- Rendered document content
) - The number of rows you wish to add or remove. E.g: 1 Position (Int32) - The row where the insertion
…) - The number of rows you wish to add or remove. E.g: 1 Row Position (Int32) - The row where the insertion
…whether the activity adds or removes rows. ・Add: Add rows to the document. ・Delete: Remove rows from
- Title
Excel Insert Or Delete Rows
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelInsertOrDeleteRows == **Description** == Adds or removes a specified number of rows at a certain position
…of row (Int32)** - The number of rows you wish to add or remove. E.g: 1 * **Position (Int32
…" == **Properties** == **Destination** * **Number of rows (Int32)** - The number of rows you wish to add
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
…the input data as a CSV. This field only supports Boolean values (True, False). The default value is False
…separator. This field supports only String variables. Input Input (String)* - The field that you add
- 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
Excel Read Row
Located in
- Rendered document content
. 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
…of an Excel row beginning from the cell specified in the StartingCell field: and stores it in an lEnumerable
- Title
Excel Read Row
- Location
Excel Read Row
- Raw document content
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
…the values of an Excel row beginning from the cell specified in the StartingCell field: and stores
Read Row
Located in
- Rendered document content
(String)* - The cell from which to start extracting the row data. By default, this is filled in with "A1
…" Starting Cell (String)* - The cell from which to start extracting the row data. By default, this is filled
…RCA.Activities.Excel.ReadRow Description Reads the values from a row beginning with the cell
- Title
Read Row
- Location
Read Row
- Raw document content
extracting the row data. By default, this is filled in with "A1". E.g: "A1" == **Properties
…(String)*** - The cell from which to start extracting the row data. By default, this is filled in with "A1
…" %) ((( RCA.Activities.Excel.ReadRow == **Description** == Reads the values from a row beginning with the cell specified
Filter Data Table
Located in
- Rendered document content
variable by specifying conditions in the Filter Wizard window. The activity can keep or delete rows
…. (* is mandatory) In the body of activity Filter Wizard - Set filter for rows, set output columns Properties Input Data Table (DataTable)* - The DataTable variable that you want to filter. This field supports
- Title
Filter Data Table
- Attachment name
filter data table.jpg
- Location
Data Table
- Raw document content
conditions in the Filter Wizard window. The activity can keep or delete rows or columns according
…button so that you can access the wizard and customize your settings at any time. [[[[image:filter data table.jpg||class="img-thumbnail"]]>>attach:filter data table.jpg]] (* is mandatory) == **In the body
Remove Duplicated Rows
Located in
- Rendered document content
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.
- Title
Remove Duplicated Rows
- Location
Data Table
- Raw document content
" %) ((( 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 (Checkbox) **- Check if you want to publicize it. Remember to consider data security requirements before