Tips on handling multiple join conditions between 2 data models?

I noticed that only 1 join condition can be defined when creating a relationship between 2 data models in Holistics:

We have 2 models that should be joined on 2 columns:

  1. Month
  2. User ID

Currently, we create surrogate keys within the data models (i.e. concat of Month and User ID), and defined the relationship based on the surrogate key. However, I’m not sure if I’m misunderstanding how the UI works, and whether there are more intuitive ways to achieve the above.

I would be happy to hear suggestions or how others are approaching this scenario! :smile:

1 Like

Hi Jing Yu @jingyu,

Thank you for sharing your questions on our community! It’s been a while since your last post.

Your approach to “create surrogate keys within the data models (i.e. concat of Month and User ID), and defined the relationship based on the surrogate key” is spot on. Currently, we only support that approach.

But I could definitely see how we could improve our feature based on your question. I will be sure to add your input to our backlog for further consideration.

Cheers!
Daphne

1 Like

We’d like to back this request too. We have a number of models that could join by Date+ID, or Type+ID and are currently creating a number of surrogate keys. This feature would provide much better functionality for working just in the Holistics platform.

1 Like