Search: add-data-column

the structured text. This activity enables you to select column and row separators according to which the table

(default) - blocks the process from continuing the execution. Fixed formatting options Column Sizes (IEnumerable< Int32 >) - Specifies the size of the columns that are to be created in the table. This field

Generate Data Table

generate data table.jpg

Data Table

Generate Data Table

(String)*** - The field that you add unstructured data to convert into a table. Only String are supported

. This activity enables you to select column and row separators according to which the table is generated. [[[[image:generate data table.jpg||class="img-thumbnail"]]>>attach:generate data table.jpg]] (* is mandatory

a specified CSV File. (* is mandatory) In the body of activity File Path (String) - You can add the file

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

Path (String)** - You can add the file path of the CSV here. String supported only. == **Properties

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

DataTable to a CSV File. (* is mandatory) In the body of activity 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

** == * **File Path (String)** - You can add the file path of the CSV here. String supported only. * **Data

” * **Add Headers (CheckBox)** - Boolean that specifies if the column names from the DataTable will be added

** == **Input** * **Data Table (DataTable)*** - Specifies the DataTable to be written in the CSV file

will be shown as below: No Panel Description 1 Add new trigger Click here to create a new trigger 2 Edit

the information in the tab: Basic No Column/Label Description Type Maximum Is Mandatory? 1 Trigger Name Fill

the information in the tab: Action No Column/Label Description Type Maximum Is Mandatory? 1 Action type Choose

;" %)Description |1|(% style="width:264px" %)**Add new trigger**|(% style="width:816px" %)Click here to create

.png||height="358" width="342"]] (% style="width:1043px" %) |=No|=Column/Label|=Description|=Type

.png||height="432" width="409"]] (% style="width:1043px" %) |=No|=Column/Label|=Description|=(% style

for. This field supports only strings and String variables. Eg: “Name of column” Data Column (DataColumn

and String variables. Eg: “Name of targeted column” Data Column (DataColumn) - Specifying a DataColumn

and the column specified in the Target Column property category. (* is mandatory) Properties Input Lookup

Look Up Data Table

look up data table.jpg

Data Table

Look Up Data Table

in the Target Column property category. [[[[image:look up data table.jpg||class="img-thumbnail

to search for. This field supports only strings and String variables. Eg: “Name of column” * **Data Column

. Eg: “Name of targeted column” * **Data Column (DataColumn)** - Specifying a DataColumn variable here

: “Column name here”. Data Column (DataColumn) - The variable containing the column you want to sort

RCA.Activities.Core.SortDataTables Description This activity allows you to sort data tables in ascending or descending order, based on the values of a specified column. (* is mandatory) Properties

Sort Data Table

sort data table.jpg

Data Table

Sort Data Table

" %) ((( RCA.Activities.Core.SortDataTables == **Description** == This activity allows you to sort data tables in ascending or descending order, based on the values of a specified column. [[[[image:sort data table.jpg||class="img-thumbnail

: “Column name here”. * **Data Column (DataColumn)** - The variable containing the column you want to sort

 variables to the Workflow. You can add multiple variables, but you can only add one by one. No Column

Workflow as below: No Column/Label Description 1 Action Available actions to manage the Log of said

create a new Task related to this workflow. *ADD SCHEDULE: Quickly add a schedule related

]] |=No|=Column/Label|=Description |1|Action|((( Available actions to manage the Log of said Workflow. Includes

a new Task related to this workflow. *ADD SCHEDULE: Quickly add a schedule related to this workflow

** == [[image:image-20221028095456-10.png]] |=No|=Column /Label|=Description|=Type|=Maximum|=Input Requirement |1

RCA.Activities.Excel.ExcelReadColumn Description Read all data into column has determined

 - The cell from which to start extracting the column data. By default, this is filled in with "A1". E.g: "A1

)* - The cell from which to start extracting the column data. By default, this is filled in with "A1". E.g: "A1

Excel Read Column

Excel Read Column

RCA.Activities.Excel.ExcelReadColumn == **Description** == Read all data into column has

to start extracting the column data. By default, this is filled in with "A1". E.g**:** "A1

" * **Starting Cell (String)*** - The cell from which to start extracting the column data. By default

a DataRow variable according to a specified column. (* is mandatory) In the body of activity DataTable row (DataRow)* - The DataRow object from which a value is to be retrieved. Properties Input Column

, the ColumnName and ColumnIndex properties are ignored. Column Index (Int)* - The index of the column whose value

Data Table

according to a specified column. [[[[image:get row item.jpg]]>>attach:get row item.jpg

a value is to be retrieved. == **Properties** == **Input** * **Column (DataColumn

and ColumnIndex properties are ignored. * **Column Index (Int)*** - The index of the column whose value

documents to extract data. Staff can create a new learning model by following these below steps: Step 1: Go to "Learning Models" tab Step 2: Choose "Add Learning Model" button Step 3: Input Model

choose base model, this new model will get all the fields that the based model has and staff can add more

, send the learning models to production and use them to run on actual documents to extract data. Staff

"]] (% class="box infomessage" %) ((( **Step 2**: Choose "Add Learning Model" button ))) [[image:image

, this new model will get all the fields that the based model has and staff can add more fields by clicking