Search: generate-data-table

position in the table. (* for mandatory) In the body of activity Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Table name (String) - Table name you

must be made. E.g: "Sheet1" Table name (String) - Table name you want to insert. E.g: "Table1" Misc

Excel Insert Columns Table

Excel Insert Columns Table

" %) ((( RCA.Activities.Excel.ExcelInsertColumnsTable == **Description** == Adds a specified column at a certain position in the table. [[image:image

)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" * **Table name (String)** - Table name you want to insert. E.g: "Table1" * **Column name (String)** - Name of column you want

the documents, however, it can be changed later). Note: The default Document type for a new tenant is "General

for reviewing documents (if need). Step 5: Click "OK" button to complete creating a new pipeline. Table

is "General Invoice". If your company would like to use other document types, please contact our akaBot

" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) )))

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

[17]Extract Structured Data

[17]Extract Structured Data

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

target element*** - Chooses the element to verify its existence. This activity will generate a string

of activity File path (String) - You can add the file path of the CSV here. String supported only. Data Table (DataTable) - The data table you want to append. Properties File File Path (String)* - The file path of the CSV file E.g: “C:\CSVFolder\clientList.csv” Input Data Table (DataTable)* - Specifies the DataTable

of the CSV here. String supported only. * **Data Table (DataTable)** - The data table you want to append

\clientList.csv” **Input** * **Data Table (DataTable)*** - Specifies the DataTable to be appended to the CSV

)** - If you check it, the data of this activity will be shown in the log. Be careful, consider data security

: 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

Extract Structured Data

Extract Structured Data

** * **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

** == * **Open Wizard*** - Chooses the element to verify its existence. This activity will generate a string

Automation of Fields Capture Custom Table Data Configure Automation Type for Pipeline Configure Fields for Data Extraction

[6] Customize Data Extract

Customizing Data Extract

* [[Automation of Fields>>path:/bin/view/akaBot%20Vision/Customizing%20Data%20Extract/Automation%20of%20Fields%20in%20akaBot%20Vision/]] * [[Capture Custom Table Data>>path:/bin/view/akaBot%20Vision

/Configure%20Automation%20Type%20for%20Pipeline%20/]] * [[Configure Fields for Data Extraction>>path:/bin

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

Data Table

) == **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

(milliseconds). E.g: 30000 Output Result (Data Table) - The outputted data with type = ‘DataTable’. Not allow

RCA.Activities.NativeBrowser.ExtractStructuredData Description The Extract Structured Data allows you to extract structured data from a specified webpage. (*For mandatory) In the body of activity

Extract Structured Data (NB)

Extract Structured Data (NB)

(Data Table)** - The outputted data with type = ‘DataTable’. Not allow white space in output’s name

" %) ((( RCA.Activities.NativeBrowser.ExtractStructuredData == **Description** == The Extract Structured Data allows you to extract structured data from

** == * **Pick target element*** - Chooses the element to verify its existence. This activity will generate

to add a collection of items to a data table to a specific queue. Once it is added to the queue

) - The data table that you want to add the queue into. QueueName (String) - The queue to which the new queue

Output Result (DataTable) - This is the data table that you have added to the queue.

of items to a data table to a specific queue. Once it is added to the queue, the items’ status is changed

. The default value is: AllOrNothing * **Queue Items DataTable (DataTable)** - The data table that you want

**Output** * **Result (DataTable) **- This is the data table that you have added to the queue

After importing the document successfully and the data extraction process is successfully finished

, 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

="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

in each field that has been detected incorrectly [[image:image-20220420193327-2.png||data-xwiki-image