Guidance Needed for Appending Datasets

Question & Answer
, , ,
1

Hello,

I am seeking guidance on how to append two datasets that have already been created using SQL queries. While I have observed that the Query Mode provides a Join clause, I have not found an option for appending datasets. Could you please advise me on the appropriate method to accomplish this task?

Thank you for your assistance.

Best,
Vaibhav Narwade.

2

Hi @Vaibhav.narwade - If both the data sets ( custom SQLs) are pointing to same data source, you need to create another data sets and use custom sql and use"union" in sql and do the union. You can not use Union directly in data sets ( as per my understanding). If both data sets are from different data sources, you may not able to do union in quicksight ( that is the current limitation i guess).

Hi @DylanM @David_Wong @duncan - any advise.

Regards - Sanjeeb

1 Like
3

Hello @Sanjeeb2022 ,

Aware about the Union function in SQL,
For your information Both datasets are coming from the different data sources,
curious about how to append those two tables using Quick sight at Data Sets Level (Query Mode).

Best,
Vaibhav Narwade.

4

Ok. Unfortunately I do not think it is possible at this moment. We have to wait for QuickSight team for their help on this.

Regards - Sanjeeb

6

Hi @Vaibhav.narwade,

Maybe you can try using something like Athena to do the union before you bring the data to QuickSight.

1 Like
7

Good morning,

Thank you all for your valuable guidance on this matter. I will proceed with data manipulation at the database level.

Best,
Vaibhav Narwade.

8

Hi @Vaibhav.narwade

You mentioned you had two datasets and there may be a reason why they were separate. If you still want that for some purposes in QuickSight, consider including a separate virtual column in your query at the database level when you are doing the union to identify the two sets distinctly. You can use that as a filtering layer in QuickSight if you want.

Regards,
Giri

1 Like
9

Hello Everyone,

Thank you for your valuable guidance.
It means a lot to me. I have combined the two datasets and created a single table.

Best,
Vaibhav

1 Like
10

Hi @Vaibhav.narwade - You have fixed the issue as both of your tables are from same data source. Imagine if you have data coming from different sources, how you can do the merge. I still believe this is a feature request we should request Quicksight team.

Hi @DylanM @duncan - At present we do not have union is not available in QuickSight, Is this something we can request, please advise.

Regards - Sanjeeb

2 Likes
11

Hello @Sanjeeb2022,

Yes, this should be a feature of QuickSight.

Best,
Vaibhav Narwade

12

Thanks for tagging me @Sanjeeb2022! I will go ahead and tag this as a feature request @Vaibhav.narwade.

3 Likes