Is there any way to combine two SPICE datasets data

Question & Answer
, ,
1

I need to combine two SPICE datasets where both of them are having same number of columns and datatypes. I tried to do this: Datasets > Edit Dataset > Add data, but there the only option for merging the datasets together was a join operation.
Example: if I have a dataset with M -rows and N-columns and another one with M2 Rows and N columns, I would like that the final dataset after merging/concatenation would be M + M2 rows and N columns

2

Hi @Nikhitha - At present Union operation is not available in QuickSight. It is already in the feature request. We have to wait for that.

Tagging @Max for the further details.

Regards - Sanjeeb

1 Like
3

I can mark it as a feature request

1 Like
4

Hi @Sanjeeb2022 and @Max , thanks for marking it as a feature request, May I know the timeline to get the feature available, need to plan the work around and incorporate till it is released.

5

I do not have a timeline.

I would suggest trying to do this in SQL as UNION is a very common expression there.

1 Like