December 2018
Beginner to intermediate
404 pages
10h 14m
English
The examples in the previous section were quite simple, but the data files can become more complex once we start using relational fields, linking records from several tables.
We handled Partner records used in Books. We will now look at how we can represent the reference for these Partners in a CSV file for Book data. In particular, we have a many-to-one (or a foreign key) relation for the Publisher (publisher_id field) and a many-to-many relation for the Authors (author_ids field).
In the CSV file header line, relation columns should have /id appended to their name. It will reference the related records using external identifiers. In our example, we will load the book publisher in a publisher_id/id field, ...
Read now
Unlock full access