Search: join-data-table
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Location
- 389Activities
- 17akaBot Vision
- 12akaBot Center
- 4akaBot Insights
- 3Data Service
- … 4 more
Creator
- 255admin
- 68Giang Tran
- 55Tuan Nguyen
- 35Nga Nguyen
- 9Nhan Nguyen
- … 2 more
Last modification date
Creation date
Object type
Uploaded by
- 141Nga Nguyen
- 101Nhan Nguyen
- 72Giang Tran
- 55Tuan Nguyen
- 46admin
- … 3 more
Upload date
[3] Configure Fields for Data Extraction
Located in
- Rendered document content
Each Pipeline defines the structure of Data fields that akaBot Vision extracts. Description When editing this structure you have two options: Use pre-trained Data fields – AkaBot Vision’s Generic AI engine has been pre-trained to recognize specific Data fields and enables you to start extracting data
- Title
[3] Configure Fields for Data Extraction
- Location
Customizing Data Extract
…Configuring Fields for Data Extraction
- Raw document content
="wikigeneratedid" id="HParagraph1" %) Each Pipeline defines the structure of Data fields that akaBot Vision
…options: * Use pre-trained Data fields – AkaBot Vision’s Generic AI engine has been pre-trained to recognize specific Data fields and enables you to start extracting data without any additional training
Execute Query
Located in
- Rendered document content
in the SQL parameter. ・TableDirect - Invokes all records from a table. Output Data Table (DataTable
…Configure Connection - Set connection string, data source, data provider. Edit Query - SQL command
…to consider data security requirement before using it. Display Name (String) - The name of this activity. You
- Raw document content
in the SQL parameter. ・TableDirect - Invokes all records from a table. **Output** * **Data Table (DataTable
…connection string, data source, data provider. [[image:https://docs.akabot.com/bin/download/Activities
…to consider data security requirement before using it. * **Display Name (String)** - The name of this activity
Excel Copy Paste Range
Located in
- Rendered document content
or sheet (including values, formulas, table format, and cell format) and pastes it to another location
…Destination Cell (String)* - The starting cell where you want to paste the copied data. This field supports
…the copied data into. This field supports only strings and String variables E.g: “TargetSheetName” Input
- Raw document content
, table format, and cell format) and pastes it to another location in the current workbook
…to SpeadSheet** * **Destination Cell (String)* **- The starting cell where you want to paste the copied data
…)*** - The sheet you want to paste the copied data into. This field supports only strings and String variables E.g
Execute SOQL
Located in
- Rendered document content
. Only Data Table variable supported. Salesforce Status – The status returned from Salesforce once
- Raw document content
of running the SOQL command in Salesforce, stored in a DataTable variable. Only Data Table variable supported
Read CSV File
Located in
- Rendered document content
Data Table (DataTable) - Represents the output DataTable that contains the information obtained from
…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
, it is selected. **Output** * **Data Table (DataTable)** - Represents the output DataTable that contains
…” **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
Quit Browser (NB)
Located in
- Rendered document content
and structure your code better. Public (Checkbox) - Check if you want to public it. Remember to consider data security requirement before using it. Default is uncheck. Table of Content
- Raw document content
)** - Check if you want to public it. Remember to consider data security requirement before using it. Default is uncheck. ))) (% class="akb-toc" %) ((( (% class="akb-toc-title" %) ((( Table of Content ))) {{toc depth
[1] Design Form
Located in
- Rendered document content
Table Tabs Well Data Include components used to collect data Hidden Container Data map Data grid Edit
…the ability to collect user data UI components are divided into 5 main groups, based on their functions
…to fill in. Then click Save when you are done. The below table describes frequently used configure
- Raw document content
|((( * HTML element * Content * Columns * Field set * Panel * Table * Tabs * Well ))) |Data|Include components used to collect data|((( * Hidden * Container * Data map * Data grid * Edit grid * Tree ))) |Premium
…provide users the ability to collect user data [[image:1695034818758-663.png||height="379" width="1014
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
…Public (Checkbox) - Check if you want to public it. Remember to consider data security requirement before
- Raw document content
in a table, range, or sheet at the specified location. This only can be used in Excel Application Scope
…at. **Misc** * **Public (Checkbox)** - Check if you want to public it. Remember to consider data security
…="akb-toc-title" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) #end {{/velocity}}
[17]Extract Structured Data
Located in
- Rendered document content
further. The default amount of time is 30000 milliseconds. E.g: 30000 Output Result (Data Table
…RCA.Activities.Browser.ExtractStructuredData Description The Extract Structured Data allows you to extract structured data from a specified webpage. (* For mandatory) In the body of the activity Pick
- Title
[17]Extract Structured Data
- Location
[17]Extract Structured Data
- Raw document content
of time is 30000 milliseconds. E.g: 30000 **Output** * **Result (Data Table)* **- The outputted
…" %) ((( RCA.Activities.Browser.ExtractStructuredData == **Description** == The Extract Structured Data allows you to extract structured data from
…(String)** - This property allows you to input the page source contained the Structure Data needed
Extract Structured Data
Located in
- Rendered document content
: 30000 Output Result (Data Table) - The outputted data with type = ‘DataTable’.
…RCA.Activities.Common.ExtractStructuredData Description The Extract Structured Data allows you to extract structured data from a specified webpage. (*For mandatory) In the body of activity Open
- Title
Extract Structured Data
- Location
Extract Structured Data
- Raw document content
** * **Result (Data Table)** - The outputted data with type = ‘DataTable’. ))) {{velocity
…" %) ((( RCA.Activities.Common.ExtractStructuredData == **Description** == The Extract Structured Data allows you to extract structured data from
…milliseconds. E.g: 200 **Input** * **Selector (String)** - The outputted data with type 'DataTable'. **Misc