- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
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?