# Combine Tables

### Overview

This procedure combines multiple tables and merges them into a single table based on specified criteria. This is useful when you have related data spread across multiple sources and want to bring it all together for easier analysis or reporting.

### Input Concepts

| Concept            | Type            | Description                                                                                                                                         | Default    | Required |
| ------------------ | --------------- | --------------------------------------------------------------------------------------------------------------------------------------------------- | ---------- | -------- |
| `tables`           | list of tables  | The tables to be combined.                                                                                                                          | No default | Yes      |
| `excluded columns` | list of strings | Columns to be excluded from the final table.                                                                                                        | No default | No       |
| `included columns` | dictionary      | Specifies which columns to include from each table. The dictionary keys are table identifiers, and the values are lists of column names to include. | No default | No       |
| `same columns`     | list of strings | Columns that are considered the same across tables and can be merged.                                                                               | No default | No       |

### Output Concepts

| Concept | Description                                                                        |
| ------- | ---------------------------------------------------------------------------------- |
| `table` | A single table that combines the input tables according to the specified criteria. |

### Examples

#### 1. Combine the Tables

```
combine the tables
```

#### 2. Combine the Tables with Optional Arguments

```
combine the tables
    the excluded columns are "ID", "Timestamp"
    the same columns are "Name", "Email"
```