Hi. I just discovered something called “Identifier Join Tables” in the data source configuration options. Can they be used for cases where I need to join experiment exposures with metrics by TWO columns instead of one?
We normally use a single identifier for joining, but there are cases when we need to join experiments exposures with metric data using two separate identifiers using “AND” clause
09/05/2023, 5:41 PM
as each metric has an identifier, and if the experiment identifier doesn’t match the metric identifier, that’s when the join table is used
so for your case, I Would suggest creating a new identifier that is the union or just concat the the identifiers