Replace Q Topic Dataset

Q&A
, ,
1

Is it possible to replace a Q Topic’s dataset? Similar to how you can replace a dataset in an Analysis.

Is replacing necessary? Or should the new dataset just be added to the Topic?

2

Hello there,

Welcome to the QS community.

I guess you could go into topic > data > DataSet then remove the existing one and add the desired one. have you tried that ?

I assume its more or less similar to creating to new one just that the name of the topic remain same which can be edited any point of time.

Hope this helps.
Cheers,
Deep

3

Hello there,

We have not heard from you. I assume the issue has been resolved. I will mark previous answer as solution. Let us know other wise.

Cheers,
Deep

4

Hey Deep, sorry for the slow response. I lost track of this.

I was hoping for a solution similar to the data set replace feature in an Analysis, but I think your solution will work. The new dataset will be an exact copy of the existing, it will just draw from a new data source.

Can you talk me through this?

My biggest concern is the details, friendly name and synonyms for each data field won’t be preserved on the new data set. Reviewed questions, and pinboard items are also a concern. Will this all need to be “rebuilt” on the new data set?

Thanks!

5

Hello @e451-timothy and @Deep !

@e451-timothy have you tried @Deep 's solution above to replace the dataset for your Q topic, and if so were you able to make this work?

It has been some time since we have seen activity on this thread but we would like to still help you find a solution.

6

Hey, @WLS-D, thanks!

We’re in the process of trying @Deep’s solution, and I think it will work.

I still have my concerns from Jan 18. Mainly that the friendly name and synonyms from the existing data set will need to be manually reconfigured on the new data set. This is a big lift for wide, dimensional data sets that my organization is using. Hence asking about the ability to replace a data set like in an Analysis. I realize that’s probably a feature request, but it would be ideal.

7

Hi @e451-timothy,

The workaround is to use the API. You have to use DescribeTopic to get the topic definition, replace the original dataset id with the new dataset id, and use the updated definition with UpdateTopic.

This will preserve all your calculated fields, synonyms, etc.

8

Thanks, @David_Wong! This solves the concerns I outlined.