Search: join-data-table

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

Remove Data Column

remove data column.jpg

Data Table

Remove Data Column

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

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

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

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

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

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

, 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

. Only Data Table variable supported. Salesforce Status – The status returned from Salesforce once

of running the SOQL command in Salesforce, stored in a DataTable variable. Only Data Table variable supported

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

, 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

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

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

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

(String)** - This property allows you to input the page source contained the Structure Data needed

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

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

: 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

milliseconds. E.g: 200 **Input** * **Selector (String)** - The outputted data with type 'DataTable'. **Misc