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"
}