Search: join-data-table

Join Table Wizard - set join condition and join type Properties Input Data Table1 (DataTable)* - The first table that you want to use in the Join operation, is stored in a DataTable variable. This field

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

Join Data Tables

join data table.jpg

Join Data Table

Data Table

"]]>>attach:join data table.jpg]] (* is mandatory) == **In the body of activity** == **Join Table Wizard - **set

** * **Data Table1 (DataTable)*** - The first table that you want to use in the Join operation, is stored

Table\ **Option** * **Join Type (JoinType)** - INNER/LEFT/FULL. **Output** * **Output Data Table

Input Data Table (DataTable)* - The DataTable variable that you want to filter. This field supports

. Output Data table (DataTable) - the filtered Data table as an output of the activity, stored

to consider data security requirements before using it. Display Name (String) - The name of this activity. You

Filter Data Table

filter data table.jpg

Data Table

.png||height="341" width="482"]] == **Properties** == **Input** * **Data Table (DataTable

. **Output** * **Data table (DataTable)** - the filtered Data table as an output of the activity, stored

button so that you can access the wizard and customize your settings at any time. [[[[image:filter data

and descriptions must match the ones from the database table. Table Name - The SQL table in which the data

to access the database. E.g: “System.Data.SqlClient” Input Data Table (DataTable)* - The DataTable

the ones from the database table. Table Name (String)*- The SQL table in which the data is to be inserted

Insert Data Table

Insert Data Table

and descriptions must match the ones from the database table. * **Table Name **- The SQL table in which the data

” **Input** * **Data Table (DataTable)*** - The DataTable variable that will be inserted into the Table

(String)***- The SQL table in which the data is to be inserted. E.g: “TargetedTable” **Misc** * **Public

at: [email protected] for more assistant. Step 4: Choose one or more users to join this pipeline for reviewing documents (if need). Step 5: Click "OK" button to complete creating a new pipeline. Table

:1704877579310-775.png||height="377" width="566"]] **Step 4**: Choose one or more users to join this pipeline

" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) )))

and choose data type is "Table". Step 3: (This step is optional) Turn on button "Required" to set require

and data type for each column Step 6: Click "Save" button Table of Content

and Table Field 1. Add Form Field Step 1: On Add Learning Instance screen, click "Add Field" button

the table name on "Label" field and choose data type is "Table". ))) [[image:image-20221028164141-11.png

types of fields: Form Field and Table Field == **1. Add Form Field** == (% class="box infomessage

the field name on "Label" field and choose data type for field on "Data Type" field ))) [[image:image

of the activity to organize and structure your code better. E.g: Get the data table Public (Checkbox) - If you

using it. Output Data Table (DataTable)- The Table is extracted from the Word Document and stored

RCA.Activities.Word.GetTable Description This activity allows you to retrieve a table from

Get Table

Get Table

the data table * **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. **Output** * **Data Table (DataTable

== **Description** == This activity allows you to retrieve a table from a Word Document and return

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

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

to add a collection of items to a data table to a specific queue. Once it is added to the queue

) - The data table that you want to add the queue into. QueueName (String) - The queue to which the new queue

Output Result (DataTable) - This is the data table that you have added to the queue.

of items to a data table to a specific queue. Once it is added to the queue, the items’ status is changed

. The default value is: AllOrNothing * **Queue Items DataTable (DataTable)** - The data table that you want

**Output** * **Result (DataTable) **- This is the data table that you have added to the queue