> For the complete documentation index, see [llms.txt](https://docs.visualyze.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.visualyze.ai/rpa-studio/data/datatable/apply-datatable-operations.md).

# Apply DataTable Operations

This activity is used to compare DataTables to get matched, unmatched, or combine the list of all rows in the DataTable inputs.

### Input

* **DataTable 1 :** [`DataTable Variable`](/getting-started/rpa-studio/variables/activity-variables.md#datatable)\
  Specifies the first DataTable to compare values.<br>
* **DataTable 2 :** [`DataTable Variable`](/getting-started/rpa-studio/variables/activity-variables.md#datatable)\
  Specifies the second DataTable to compare values.<br>
* **DataTable Operations** **:** \
  Specifies the type of data table operations to be used on the DataTable inputs. The data table operations available are:-
  * `Except` - To retrieve unmatched records from the first table.
  * `Intersect` - To retrieve all the rows which are in both tables.
  * `Union` - To retrieve the combined data from both the DataTable inputs. It does not repeat the DataRow even if it exists in multiple DataTables.

### Output

* **Output:** [`DataTable Variable`](/getting-started/rpa-studio/variables/activity-variables.md#datatable)\
  Specifies the variable that stores the resulting data table of the DataTable operation.\ <br>