---
title: "other_tables.json"
slug: "other-tables-json"
updated: 2022-07-27T15:22:15Z
published: 2022-07-27T15:22:15Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://code.tag.bio/llms.txt
> Use this file to discover all available pages before exploring further.

# other_tables.json

The *other_tables* attribute in the **config** object is an array of **table** objects used to add data from delimited files or database tables other than the *entity_table*.

All of the rows / columns processed by each *other_table* will be available to the **parsers** included in its *parsers* attribute, or via *table_alias* when **parsers** are registered from the **config** file.

## Attribute - id_columns

```
{
  "table_alias": "oooo",
  "table": "../somewhere-outside-the-project-repo/oooo.csv",
  
  // Defines how the rows of this table will map to entities
  // in the Data Product
  //
  "id_columns": { 
  
    // Where ooo1 is a column in this file, and 
    // kkkk is a unique or foreign key in the entity_table
    //
    "ooo1": "kkkk",
    
    ... // Multiple, compound ID matches are possible
  }
}
```

## Attribute - transpose

Here's a version of the *other_tables* form of **table** object that has transposed source data - i.e. column headers represent unique or foreign keys to **entities** and rows represent data for those **entitites**.

```
{
  "table_alias": "oooo",
  "table": "../somewhere-outside-the-project-repo/oooo.csv",
  
  // I'm transposed - match my column headers to entities
  // via unique or foreign key defined in the entity_table
  //
  "transpose": "kkkk"
}
```