other_tables
  • 13 Dec 2022
  • 1 Minute to read
  • Contributors
  • Dark
    Light
  • PDF

other_tables

  • Dark
    Light
  • PDF

Article summary

The other_tables array contains table objects to join in a "one-to-many" relationship from the one entity_table and additional source data. Source data to be joined in a "one-to-one" relationship should be attached to the entity_table within a joins array.

All available attributes of the parent table object apply.

[
  {
    "table": "~/dir_with_source_data/ooo1.csv",
    "table_alias": "ooo1",
    "id_columns": {
      "ooo1": "uuuu"
    },
    "parsers": "config/parsers/ooo1_parsers.json"
  },
  {
    "table": "~/dir_with_source_data/ooo2.csv",
    "table_alias": "ooo2",
    "id_columns": {
      "ooo2": "uuuu"
    },
    "parsers": "config/parsers/ooo2_parsers.json"
  }
]

id_columns

usage: required
The id_columns object is a key, value pair of strings which defines the columns used to connect two data sources. The key of this object is a column within the joined table and the value is a column within the parent table.


Was this article helpful?

What's Next