Create a dataset with the union all of two datasets

Q&A
, ,
1

Hello,

I have one dataset (DS1) in SPICE. This dataset has the info until the last day of the previous year. This dataset is only refreshed the first day of each year.

I have other dataset (DS2) in SPICE. This dataset has exactly the same columns as DS1. DS2 is refreshed every day with the info of the currently year.

I want to generate a new dataset (DS3) with the info of DS1 + DS2. I would like and UNION ALL.

Thanks very much for your help

2

Hi @edcaso ,

As far as I know this is a feature other peers have requested, but we do not have at the moment a way to do it.

The only thing that can be done at this moment btw different dataset is a join.

I hope this will soon become a new feature as you also you requested! :slight_smile:

Thank you,

Andrea

1 Like
3

Hi @edcaso,

I’ll mark this as a feature request to promote visibility to the support team.
Let us know if you have any additional questions or comments to add; if we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

1 Like
4

Hi @edcaso,

Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.

Thank you

1 Like
5

Thanks @andrepgn

I have resolved the issue with a join. And I hope the posibility of use of UNION ALL soon.