Datasets and union

[samzabhi]

I have multiple CSV files which i want to union/concatenate. Is there a way to do this in quicksight?

[ErikG]

Hi @samzabhi
Please have a look at

Datasets based on multiple Amazon S3 files - Amazon QuickSight

Or

UNION two datasets together instead of JOIN?

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…

BR

[vignessh.b]

@samzabhi /@ErikG The new data preparation experience in Quick Sight (launched last week) now supports advanced transformations like Append (Union All), Pivot, Unpivot, ListAgg and many more capabilities. Amazon Quick Sight announces the general availability of a new data preparation experience - AWS