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
- 82Activities
- 11akaBot Center
- 5Data Service
- 5akaBot Vision
- 2App Connect
- … 5 more
Last author
- 34admin
- 25VuNH54
- 20Nhan Nguyen
- 11Giang Tran
- 8Tuan Nguyen
- … 3 more
Creator
- 61admin
- 26Giang Tran
- 14Tuan Nguyen
- 4Nga Nguyen
- 4Nhan Nguyen
- … 1 more
Last modification date
Creation date
Object type
Uploaded by
- 37admin
- 36Nhan Nguyen
- 25Giang Tran
- 14Tuan Nguyen
- 7Nga Nguyen
- … 3 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
Excel Insert Rows
Located in
- Rendered document content
RCA.Activities.Excel.ExcelInsertRows Description This activity allows you to add more rows to insert one or more rows in a table, range, or sheet at the specified location. This only can be used
…(String)* - The name of the sheet that you want to insert row. E.g: “Employee Name” Number of row (Int
- Title
Excel Insert Rows
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelInsertRows == **Description** == This activity allows you to add more rows to insert one or more rows
…of the activity** == * **Sheet name (String)*** - The name of the sheet that you want to insert row. E.g: “Employee Name” * **Number of row (Int) **- Number of rows you want to insert in Excel sheet E.g: 5
[3] Review Document
Located in
- Rendered document content
, akaBot Vision provides users with the capability to add or remove rows in a table To insert a row, you can click "+" icon To delete a row, you can click "x" icon To add a new row at the end of the table, you can click on the "Add row" button These features enable users to easily modify the table to meet
- Raw document content
" icon * To add a new row at the end of the table, you can click on the "Add row" button These features
…="wikigeneratedid" %) After importing the document successfully and the data extraction process is successfully
…with this status in the “To review” tab in the user interface. [[image:image-20220420193327-1.png||data-xwiki
For Each Row
Located in
- Rendered document content
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
- Title
For Each Row
- Attachment name
for each row.jpg
- Location
Data Table
…For Each Row
- Raw document content
) == **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
…" %) ((( RCA.Activities.Core.ForEachRow == **Description** == This activity allows you to execute an action once for each row
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