How to set up schema and dataset with one to many relationship | Community
Skip to main content
Level 4
January 27, 2026
Question

How to set up schema and dataset with one to many relationship

  • January 27, 2026
  • 0 replies
  • 7 views

We have a customer dataset and dataflow already set up. The data structure is set up to accommodate a one to one key-value pair; one key and one value such as gender (key) = male (value). We are looking to ingest data into RTCDP with a one-to-many relationship; i.e. one key with multiple values.

Sample use case:

We want to set up a key called “Products held”. There is no set number of products held for each customer. A customer could have 1 product held, or 10 or up to 100; it’s different for each customer.

E.g.

Customer001: products_held = product1; he has a single product held.

Customer002: products_held = product5, product15, product23…and so on; he has 16 products held.

Customer003: products_held = product4, product18, product30…and so on; he has 50 products held.

I assume that we will need a new schema for this and perhaps a new dataset. Please advise as to how this can be set up. If there is documentation on this, please let me know.

Thanks!