Hi @maxim
Ideally, I would do a UNION of the data from the source through a Custom SQL.
But, if you want to do it in QuickSight the following discussions could help. Basically, the suggestion is a FULL outerjoin and then creating calculated fields to combine the multiple columns created from the three source datasets.
Is it possible? I have two SPICE datasets created with Custom SQL with same columns, I want to use a UNION ALL to concatenate these datasets into one, but the only option that seems to be available in the visual editor is JOIN… Why isn’t UNION an option here? Is it hiding somewhere else?
These are both small datasets which each only take about 2 minutes to load from their queries, but using UNION ALL within a single custom query for some reason makes it take so long that it is automatically can…
It’d be nice if there was a way to perform a union (append all rows from one dataset to another, more rows) or join (key based join, more columns, and more rows depending on join) at the analysis / dashboard level.
Right now you can only perform these operations at the dataset level, for my use case users do not get access to dataset level operations just analysis / dashboard ones. Currently they are able to create calculated fields, which is awesome, but it’d be even better if they could mix t…
2 Likes