I have two datasets in Quick Sight that have the same column names and datatypes. I would like to merge them into a single dataset, similar to how the Union operation works. Is there a way to accomplish this in Quick Sight using either the GUI or CLI?
1 Like
@ali.ahmad - Unfortunately UNION operation is still not available withing Quick Sight. If your datasets are SQL based you can do that in SQL or else it had to be pre-processed before being fed into Quick Sight. I know that support for Union and Pivot are on their roadmap, but not yet available. Hope this helps!
1 Like
Hi, is there a timeline that can be shared on when this would be available in Quicksight? We are moving our reporting from Power BI to Quicksight, I have about 12 months of data I am trying to merge (all in excel) and would be good to know for my use case.
Hi @akila,
Unfortunately we can’t share our timeline here. There is a simple workaround for your use case. Put all your files in an S3 bucket, then use Quick Sight to load the S3 bucket directly or through Athena.
Hope it helps!
Thanks,
Ian
1 Like