Merging two datasets on an analysis merge them on all the other analysis

Question & Answer
,
1

I have a data set let call it ‘N’. I have merged N with another dataset ‘M’. When i merge these datasets on a fresh analysis, it has also merged them on any other analysis which the data source is N. Is there a way to undo without breaking everything. And in the future, how do i avoid this?

I might be answering my own question, but i assume i create a new dataset and use N for the source, and then merge that new one with M. So it will not update/merge the other analysis which uses N for the source, since it’s a new dataset with N and M merged

Edit: So if i have merged N dataset and M dataset yet i have not added M dataset fields to my analysis, can i remove the M dataset from the analysis and it will keep all the visuals the same - basically without breaking the analysis?

3

Hello @HarveyB-B,

As you have found out, indeed the datasets are reusable by all the analysis, so if you change the dataset, all analysis and dashboards will be affected.

I don’t exactly understand what you mean by merge, can you be a little more specific? Did you perform a join with a new dataset? If that is the case, then you can just try removing the join and that should take you back to the older version of the dataset. Regrettably, there is no way to go back to the older version after you have published your changes.

Reply to the Edit. yes, that should work just fine.

1 Like
4

Yes sorry i should’ve closed this post. I removed the dataset after it finally imported, and did not affect any of my sheets since i used no data from ‘M’.

-Thanks

1 Like