Search: look-up-data-table

the file path of the CSV here. String supported only. Data Table (DataTable) - Specifies the DataTable to be written in the CSV file. Properties Input Data Table (DataTable)* - Specifies the DataTable

\clientList.csv” Misc Public (CheckBox) - If you check it, the data of this activity will be shown in the log

** == * **File Path (String)** - You can add the file path of the CSV here. String supported only. * **Data Table (DataTable)** - Specifies the DataTable to be written in the CSV file. == **Properties** == **Input** * **Data Table (DataTable)*** - Specifies the DataTable to be written in the CSV file

, there is a confirmation pop-up. Read the content carefully then tick all checkboxes to confirm that you understand

will be also deleted. Moreover, documents usage data will be deleted from statistics Step 3: Click

" button, there is a confirmation pop-up. Read the content carefully then tick all checkboxes to confirm

data will be deleted from statistics ))) [[image:image-20221019135915-7.png||cursorshover="true

want to publicize it. Remember to consider data security requirements before using it. Display Name

in a QueueItem variable. Reference Filter Strategy - You can filter data according to the reference. There are two options: ・Start with: Look for items whose references start with the value indicated

Strategy** - You can filter data according to the reference. There are two options: ・Start with: Look for items whose references start with the value indicated in the reference field. ・Equals: looks for items

** * **Public (Checkbox) **- Check if you want to publicize it. Remember to consider data security requirements

(DataTable) - Stores the data extracted from the specified Excel range in a data table variable. Only data

” Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Range - Range of the data. If it isn’t

)- The sheet you want to read. E.g: "Sheet1" Range - Range of the data. If it isn’t specified, the whole

range in a data table variable. Only data table variables are supported ))) {{velocity

: "Sheet1" * **Range** - Range of the data. If it isn’t specified, the whole spreadsheet will be read. E.g

want to read. E.g: "Sheet1" * **Range** - Range of the data. If it isn’t specified, the whole

RCA.Activities.Excel.GetExcelColumnName Description Based on the column's index, you can look for it and returns the name to String variable. (* for mandatory) Properties Input Column Index: (Int32

the activity. Remember to consider data security requirement before using this property. Display Name (String

RCA.Activities.Excel.GetExcelColumnName == **Description** == Based on the column's index, you can look for it and returns the name to String variable. [[image:image-20230420113044-1.png

to consider data security requirement before using this property. * **Display Name (String) **- The name

Step 1: Navigate to the Data tab of the desired entity in Data Service. Step 2: To apply more filters on your results list, click Advanced Filter. The pop-up Advanced Filter will open Step 3: User Advanced Filter Select the operator: AND - to return the entries that match all conditions

[8] Advanced Filter in Data Service

Data Service

[2] How to use Data Service

[8] Advanced Filter in Data Service

(% class="box infomessage" %) ((( **Step 1: ** Navigate to the **Data** tab of the desired entity in Data Service. ))) [[image:image-20230630132517-1.png]] (% class="box infomessage" %) ((( **Step 2**: To apply more filters on your results list, click **Advanced Filter**. The pop-up Advanced Filter will open

the type of exception you are looking for and, optionally, perform an activity that informs the user about

(if available) within this block always get executed. 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

be placed in this section. * **Catches*** - Mention the type of exception you are looking

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

. Only string variables and strings are supported. Data Table - The data that you want to write

to start writing data. Only string variables and strings are supported. Data Table (DataTable)* - The data

RCA.Activities.Excel.WriteRange Description This activity allows you to write the data from

and strings are supported. * **Data Table** - The data that you want to write to the specified range

which to start writing data. Only string variables and strings are supported. * **Data Table (DataTable

" %) ((( RCA.Activities.Excel.WriteRange == **Description** == This activity allows you to write the data from a DataTable variable

are supported. E.g: “ClientNames” Data Table - The data to be added. This field supports only DataTable

in with "Sheet1". Only String variables and strings are supported. E.g: “ClientNames” Data Table (Datatable) * - The data to be added. This field supports only DataTable variables. Misc Public (Checkbox) - Check if you

". Only String variables and strings are supported. E.g: “ClientNames” * **Data Table** - The data

and strings are supported. E.g: “ClientNames” * **Data Table (Datatable) *** - The data to be added

to public it. Remember to consider data security requirement before using it. * **Display Name (String

want to add to the specified DataTable Object. String supported only. Data Table (DataTable

Public (Checkbox) - Check if you want to publicize it. Remember to consider data security requirements

to organize and structure your code better. Eg: Add Data Column Type Argument (Type) - A reference type

Add Data Column

add data column.jpg

Data Table

Add Data Column

to the specified DataTable Object. String supported only. * **Data Table (DataTable)*** - The DataTable object

DataTable. [[image:add data column.jpg||class="img-thumbnail"]] (* is mandatory) == **Properties

(Checkbox)** - Check if you want to publicize it. Remember to consider data security requirements before