# Defining new input tables

> Follow these steps to add a new table that was added to your input data.

Follow these steps to add a new table that was added to your input data.

:::note
Make sure the input data needed for your new table is available in your app. Check out [Loading data](https://docs.uipath.com/process-mining/automation-suite/2024.10/user-guide/loading-data).
:::

1. Go to the **Data transformations** editor.
2. Add the new input table to the `sources.yml` file.

   ![Sources.yml file](https://dev-assets.cms.uipath.com/assets/images/process-mining/process-mining-sources-yml-file-373396-03394ceb-1d3e940b.webp)
3. Add a new file for the input table in the **models -> 1_input** section of the **Transformations**.
4. Add the fields in the `select` statement.
   :::tip
   Use the `pm_utils.mandatory` and `pm_utils.optional` macros to define mandatory and optional fields from the [pm_utils library](https://github.com/UiPath/ProcessMining-pm-utils).
   | | |
   | --- | --- |
   | `pm_utils.mandatory` | Loads and type-casts a column. If the source column does not exist, an error is thrown. |
   | `pm_utils.optional` | Loads and type-casts a column. If the source column does not exist, a column is created with value NULL. |
   :::
5. For each field:
   1. Set the correct field type. For example `, 'double'`.
   2. Name the field using an alias. For example `as "Case_ID"`.

The following code shows an example of a table definition.

      ```
      /* Some fields in this table are optional. These fields are created in the SQL if they do not exist in the source data. */ 
      with Cases_input as ( 
         select 
            -- Mandatory 
            {{ pm_utils.mandatory(source_table, '"Case_ID"') }} as "Case_ID", 
            -- Optional 
            {{ pm_utils.optional(source_table, '"Case"') }} as "Case", 
            {{ pm_utils.optional(source_table, '"Case_status"') }} as "Case_status", 
            {{ pm_utils.optional(source_table, '"Case_type"') }} as "Case_type", 
            {{ pm_utils.optional(source_table, '"Case_value"', 'double') }} as "Case_value"
         from {{ source_table }} 
      ) 

      select*from Cases_input
      ```

To make the new fields available for use in your dashboards, the fields must be added to an output table. Check out **Adding fields** for a description on how to create output fields.

## Field types

The following table describes the different field types and their default format settings.

| Field type | Format |
| --- | --- |
| boolean | `true`, `false`, `1`, `0` |
| date | `yyyy-mm-dd` (default) |
| datetime | `yyyy-mm-dd hh:mm:ss[.ms]`, where `[.ms]` is optional. (default) |
| double | Decimal separator: `.` (dot)  Thousand separator: none |
| integer | Thousand separator: none |
| text | N/A |