Can we concatenate (do UNION all) in quicksight? I ask as I have two datasets from two different sources , which needs to be stacked together?

Question & Answer
, , , ,
1

Can we concatenate (do UNION all) in quicksight? I ask as I have two datasets from two different sources , which needs to be stacked together ?

I don’t want to join they as I want all rows to be from individual datasets to be retained.

1 Like
2

Hi @shrutisingh, welcome to the QuickSight Community. Yes, it’s possible. Joining data is done at the dataset, here is the details.

data-prep-open-join-configuration
data-prep-open-join-configuration

We hope this solution worked for you. Let us know if this is resolved. And if it is, please help the community by marking this answer as a “Solution.” (click the check box under the reply)

3

Thanks @ Xclipse- I had read above doc. I want a UNION all and not a full outer join.

4

Hi @shrutisingh - Welcome to AWS QuickSight community and thanks for posting the question. At present QS is not having UNION or UNION ALL capabilities and I believe this is already in feature request. As a work around solution, you need to transfer one source file ( possibly smaller one) to another system and using custom SQL approach you can do the union from one data source.

Hi @Xclipse - Can you please check whether this feature ( UNION and UNION ALL) is already in feature request or not. if not, please add it as this is one of the important ask as well.

Regards - Sanjeeb

5

Hi @shrutisingh, Another Post QuickSight (and most BI tools) being read-only, we cannot insert new rows of data (can only make new columns). I think this is where your question about doing UNIONS in the data prep is probably coming from? You are right that would be a solution to the latter scenario (to insert a row with a null or 0 value), but as other mentioned the only want to to a UNION is by using Custom SQL. Yes, we are looking at adding UNIONS into the data prep UI as well, but unfortunately we cannot comment on dates :slight_smile: At AWS, our roadmap is primarily driven by our customers. Your feedback helps us build a better service. I have tagged this as a feature request.