Search: extract-structured-data

can edit the name of the activity to organize and structure your code better. Eg: Remove data row.

RCA.Activities.Core.RemoveDataRow Description This activity allows you to remove a Data Row to a specified DataTable. (* is mandatory) Properties Input Data Row (DataRow)* - The DataRow object which

Remove Data Row

remove data row.jpg

Data Table

Remove Data Row

edit the name of the activity to organize and structure your code better. Eg: Remove data row

" %) ((( RCA.Activities.Core.RemoveDataRow == **Description** == This activity allows you to remove a Data Row to a specified DataTable. [[image:remove data row.jpg]] (* is mandatory) == **Properties** == **Input

of this activity. You can edit the name of the activity to organize and structure your code better. Eg: Merge Data

. (* is mandatory) Properties Input Destination (DataTable)* - The data table that takes the data from the source data table and handles the changes and missing schema. Source (DataTable)*- The data table

Merge Data Table

merge data table.jpg

Data Table

Merge Data Table

data table.jpg]]>>attach:merge data table.jpg]] (* is mandatory) == **Properties** == **Input** * **Destination (DataTable)*** - The data table that takes the data from the source data table and handles the changes and missing schema. * **Source (DataTable)***- The data table

RCA.Activities.Core.AddDataRow Description This activity allows you to add a Data Row

in the DataTable. Data row (DataRow) - The DataRow object to be added to the DataTable. If this property is set, then the ArrayRow property is ignored. Data Table (DataTable)* - The DataTable object in which you want to add

Add Data Row

add data row.jpg

Data Table

Add Data Row

" %) ((( RCA.Activities.Core.AddDataRow == **Description** == This activity allows you to add a Data Row to a specified DataTable. [[[[image:add data row.jpg]]>>attach:add data row.jpg]] (* is mandatory) == **Properties** == **Input

should map to the type of its corresponding column in the DataTable. * **Data row (DataRow

(String) - The name of this activity. You can edit the name of the activity to organize and structure your code better. E.g: [571047923] State Machine 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.

of the activity to organize and structure your code better. E.g: [571047923] State Machine * **Public (CheckBox) **- If you check it, the data of this activity will be shown in the log. Be careful, consider data security

) - The name of this activity. You can edit the name of the activity to organize and structure your code better

. The format is hh:mm:ss. E.g: 00:00:10 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.

and structure your code better. E.g: Delay * **Duration (TimeSpan)* ** - The amount of time you want to wait

check it, the data of this activity will be shown in the log. Be careful, consider data security before

to organize and structure your code better. Eg: Join Data Table\ Option Join Type (JoinType) - INNER/LEFT

RCA.Activities.Core.JoinDataTables Description This activity allows you to add different data

Join Table Wizard - set join condition and join type Properties Input Data Table1 (DataTable

Join Data Tables

join data table.jpg

Data Table

Join Data Table

of this activity. You can edit the name of the activity to organize and structure your code better. Eg: Join Data

" %) ((( RCA.Activities.Core.JoinDataTables == **Description** == This activity allows you to add different data from different tables using common values with each other. [[[[image:join data table.jpg||class="img-thumbnail

of the activity to organize and structure your code better. Eg: “Remove Data Column”

RCA.Activities.Core.RemoveDataColumn Description This activity allows you to remove a Data

is ignored. Eg: “Phone Number”. Data table (DataTable)* - The DataTable object from which the column

Remove Data Column

remove data column.jpg

Data Table

Remove Data Column

edit the name of the activity to organize and structure your code better. Eg: “Remove Data Column

" %) ((( 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 organize and structure your code better. Eg: Generate Data Table Output Output Data Table (DataTable

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

the input data as a CSV. This field only supports Boolean values (True, False). The default value is False

Generate Data Table

generate data table.jpg

Data Table

Generate Data Table

" %) ((( RCA.Activities.Core.GenerateDataTable == **Description** == Generates a DataTable variable from the structured text

. [[[[image:generate data table.jpg||class="img-thumbnail"]]>>attach:generate data table.jpg]] (* is mandatory

want to parse the input data as a CSV. This field only supports Boolean values (True, False

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

to organize and structure your code better. E.g: Throw. Throw Exception (Exception)* - Type of exception

) == **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. You can edit the name of the activity to organize and structure your code better

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