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
Result type
- 460Document
- 26Attachment
- 3Object
- 2Object property
Location
- 435Activities
- 27akaBot Vision
- 12akaBot Center
- 5Data Service
- 4akaBot Insights
- … 4 more
Last author
- 93Nga Nguyen
- 86admin
- 70Tuan Nguyen
- 63VuNH54
- 59Nhan Nguyen
- … 4 more
Creator
- 280admin
- 68Giang Tran
- 55Tuan Nguyen
- 35Nga Nguyen
- 9Nhan Nguyen
- … 3 more
Last modification date
Creation date
Object type
Uploaded by
- 143Nga Nguyen
- 140Nhan Nguyen
- 73Giang Tran
- 55Tuan Nguyen
- 50admin
- … 3 more
Upload date
- Sort by:
- Relevance
[05]For Each
Located in
- 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
Remove Data Column
Located in
- Rendered document content
is ignored. Eg: “Phone Number”. Data table (DataTable)* - The DataTable object from which the column is to be removed. Misc Public (Checkbox) - Check if you want to publicize it. Remember to consider data security
…RCA.Activities.Core.RemoveDataColumn Description This activity allows you to remove a Data
- Title
Remove Data Column
- Attachment name
remove data column.jpg
- Location
Data Table
…Remove Data Column
- Raw document content
Number”. * **Data table (DataTable)*** - The DataTable object from which the column is to be removed
…" %) ((( RCA.Activities.Core.RemoveDataColumn == **Description** == This activity allows you to remove a Data Column to a specified DataTable. [[[[image:remove data column.jpg]]>>attach:remove data column.jpg]] (* is mandatory
description
Located in
- Property value
> </div> </div> <div class="akb-card"> <div class="akb-card-title">Data Table</div> <div class="akb-card-body"> <div class="akb-link-list"> <a href="/bin/view/Activities/Data%20Table/%5B1%5D%20Release%20Notes/">Release Notes</a> <a href="/bin/view/Activities/Data%20Table
[1] Create New Learning Model
Located in
- Rendered document content
documents to extract data. Staff can create a new learning model by following these below steps: Step 1
…choose base model, staff will have to create form fields and table from scratch Step 5: Click "Save
…. With the Form Fields, staff should label both "Label" and "Value" for each field if having enough data
- Raw document content
, send the learning models to production and use them to run on actual documents to extract data. Staff
…||cursorshover="true"]] * If staff doesn't choose base model, staff will have to create form fields and table
…" for each field if having enough data in documents. This helps the model will extract data more exactly
Excel Get Workbook Sheets
Located in
- Rendered document content
to public it. Remember to consider data security requirement before using it. Display Name (String
…. E.g: Get Workbook Sheets Table of Content Output Sheet (List< String >) - List of string
- Raw document content
) **- Check if you want to public it. Remember to consider data security requirement before using
…" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) ))) **Output** * **Sheet (List< String
[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
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
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