Multiple datasets for Q Topic not wokring as expected

Question & Answer
, ,
1

Hello Team,

I am working on a Q topic that initially used one dataset containing information at the Campaign ID (CampaignID/metrics) grain. Recently, I added another dataset with the same Campaign ID (CampaignID/template) grain and enabled both datasets in the Q topic.

Im trying to get the answer for “Display metrics and template for Campaign ID 12345”

Here are my observations :

  1. I was under the impression that if there is a common key (e.g., Campaign ID) joining the two datasets, Q would automatically combine the information and provide results seamlessly. However, enabling keys in both datasets led me to a concern below.

  2. Both datasets have Campaign ID as the identifier. When I enable them, the Campaign ID field from each dataset is displayed separately in the “What’s in my Topic” section, which could confuse users.

Could you please help clarify or assist in resolving this issue?

Note: I prefer not to edit the Custom SQL to avoid increasing complexity. I would like to keep the datasets separate.

Thank you for your support!

2

Hi @adurai,

When you add two datasets to your topic, Q doesn’t combine them to answer your question. It chooses the dataset that contains the field(s) that you’re asking about. If you have questions that can only be answered by combining elements from both datasets, you should create another dataset that joins them and then used that joined dataset in your topic instead. You should be able to join them using the dataset editor without using custom SQL.