Search: join-data-table

Last modified by admin on 2022/04/24 04:58

Results 1 - 10 of 50 next page » Page 1 2 3 4 5

Join Data Tables

Last modified by VuNH54 on 2023/04/19 15:16
Rendered document content
Join Table Wizard - set join condition and join type Properties Input Data Table1 (DataTable)* - The first table that you want to use in the Join operation, is stored in a DataTable variable. This field
to organize and structure your code better. Eg: Join Data Table\ Option Join Type (JoinType) - INNER/LEFT
Title
Join Data Tables
Attachment name
join data table.jpg
Location
Join Data Table
Data Table
Raw document content
"]]>>attach:join data table.jpg]] (* is mandatory) == **In the body of activity** == **Join Table Wizard - **set
** * **Data Table1 (DataTable)*** - The first table that you want to use in the Join operation, is stored
Table\ **Option** * **Join Type (JoinType)** - INNER/LEFT/FULL. **Output** * **Output Data Table

Filter Data Table

Last modified by VuNH54 on 2023/04/19 14:34
Rendered document content
Input Data Table (DataTable)* - The DataTable variable that you want to filter. This field supports
. Output Data table (DataTable) - the filtered Data table as an output of the activity, stored
to consider data security requirements before using it. Display Name (String) - The name of this activity. You
Title
Filter Data Table
Attachment name
filter data table.jpg
Location
Data Table
Raw document content
.png||height="341" width="482"]] == **Properties** == **Input** * **Data Table (DataTable
. **Output** * **Data table (DataTable)** - the filtered Data table as an output of the activity, stored
button so that you can access the wizard and customize your settings at any time. [[[[image:filter data

[4] Capture Custom Table Data

Last modified by admin on 2023/05/14 13:20
Rendered document content
. Adding a new table In order to create a new table, click [Add Field], select Data Type = “table
A basic element in the extraction schema is the data field. However, akaBot Vision enables the capture of even more complex structures like tables. Adding a predefined table field If you are missing
Title
[4] Capture Custom Table Data
Location
Capturing Custom Table Data in akaBot Vision
Customizing Data Extract
Raw document content
, click [Add Field], select Data Type = “table” and then input the value you want to create a new table
="wikigeneratedid" id="HParagraph1" %) A basic element in the extraction schema is the data field. However, akaBot Vision enables the capture of even more complex structures like tables. == **Adding a predefined table

Excel Append Range

Last modified by VuNH54 on 2023/04/19 16:57
Rendered document content
in a Data Table variable to the end of a specified Excel spreadsheet. (* is mandatory) In the body
, this is filled in with "Sheet1". Only String variables and strings are supported. E.g: “ClientNames” Data Table
." Only String variables and strings are supported. E.g: “ClientNames” Data Table (DataTable)* - The data
Raw document content
" %) ((( RCA.Activities.Excel.ExcelAppendRange == **Description** == This activity allows adding information stored in a Data Table variable
: “ClientNames” * **Data Table** - The data to be added. This field supports only DataTable variables
: “ClientNames” * **Data Table (DataTable)*** - The data to be added. This field supports only DataTable

For Each Row

Last modified by VuNH54 on 2023/04/19 14:38
Rendered document content
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 the DataRow. Misc Public (Checkbox) - Check if you want to publicize it. Remember to consider data security
Location
Data Table
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
(Checkbox)** - Check if you want to publicize it. Remember to consider data security requirements before

Read Range

Last modified by Giang Tran on 2022/05/13 06:53
Rendered document content
(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
Raw document content
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

Write Range

Last modified by VuNH54 on 2023/04/20 10:55
Rendered document content
. Only string variables and strings are supported. Data Table - The data that you want to write
to start writing data. Only string variables and strings are supported. Data Table (DataTable)* - The data
RCA.Activities.Excel.WriteRange Description This activity allows you to write the data from
Raw document content
and strings are supported. * **Data Table** - The data that you want to write to the specified range
which to start writing data. Only string variables and strings are supported. * **Data Table (DataTable
" %) ((( RCA.Activities.Excel.WriteRange == **Description** == This activity allows you to write the data from a DataTable variable

Append Range

Last modified by VuNH54 on 2023/04/19 16:55
Rendered document content
are supported. E.g: “ClientNames” Data Table - The data to be added. This field supports only DataTable
in with "Sheet1". Only String variables and strings are supported. E.g: “ClientNames” Data Table (Datatable) * - The data to be added. This field supports only DataTable variables. Misc Public (Checkbox) - Check if you
Raw document content
". Only String variables and strings are supported. E.g: “ClientNames” * **Data Table** - The data
and strings are supported. E.g: “ClientNames” * **Data Table (Datatable) *** - The data to be added
to public it. Remember to consider data security requirement before using it. * **Display Name (String

Excel Write Range

Last modified by VuNH54 on 2023/04/20 10:42
Rendered document content
. E.g: “A10” Data Table - The data that you want to write to the specified range, as a DataTable variable. Only DataTable variables are supported. Properties Input Data Table (DataTable)* - The data
RCA.Activities.Excel.ExcelWriteRange Description This activity allows you to write the data from
Raw document content
and strings are supported. E.g: “A10” * **Data Table** - The data that you want to write to the specified
** * **Data Table (DataTable)*** - The data that you want to write to the specified range, as a DataTable
" %) ((( RCA.Activities.Excel.ExcelWriteRange == **Description** == This activity allows you to write the data from a DataTable variable

[05]For Each

Last modified by admin on 2023/10/20 10:21
Rendered document content
, data tables or other types of collections. (* for Mandatory) Properties Input Values (IEnumerable)*- Iterate through the data and process each piece of information individually. Able to input variable
it, the data of this activity will be shown in the log. Be careful, consider data security before using
Raw document content
" %) ((( RCA.Activities.Core.ForEach == **Description** == This activity allows you to loop through arrays, lists, data tables
) == **Properties** == **Input** * **Values (IEnumerable)***- Iterate through the data and process each piece
. E.g: [389861710] For Each < T > * **Public (Checkbox)** - If you check it, the data of this activity
next page » Page 1 2 3 4 5
RSS feed for search on [join-data-table]
Created by admin on 2022/04/17 14:38