Search: generate-data-table

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

" %) ((( 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

based upon the value entered in the ROI data set table, as well as the days until your defined goal

the Manual Time value entered in the ROI data set table. Goal Input Static display of your defined

to date, based upon the Manual Time value entered in the ROI data set table. Displays the Top 10

 value entered in the **ROI data set table**. ))) |((( **Goal ** )))|((( Input )))|((( Static display

in the **ROI data set table**. ))) |((( **Cumulative Time Saved** )))|((( Column Chart )))|((( Total time saved

** )))|((( Input )))|((( Displays the current total of money saved based upon the value entered in the **ROI data

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

Database Connect Database Disconnect Database Transaction Execute Non Query Execute Query Insert Data Table

/view/Activities/Database/Activities/Execute%20Query/]] * [[Insert Data Table>>url:https