# Two Dataset working together without doing any joins

**URL:** <https://community.amazonquick.com/t/two-dataset-working-together-without-doing-any-joins/26196>\
**Category:** Q&A\
**Tags:** calculations, Business-Intelligence-Engineer, quick-sight\
**Created:** [February 21, 2024, 9:46am UTC](https://community.amazonquick.com/t/two-dataset-working-together-without-doing-any-joins/26196 "2024-02-21T09:46:39Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Deepak1](https://avatars.discourse-cdn.com/v4/letter/d/8dc957/32.png) [@Deepak1](https://community.amazonquick.com/u/Deepak1)\
**Post date:** [February 21, 2024, 9:46am UTC](https://community.amazonquick.com/t/two-dataset-working-together-without-doing-any-joins/26196/1 "2024-02-21T09:46:39Z")

</div>

Hello Team,

Warm Regards!

Recently I was working on one problem,  
where I have two datasets Dataset “Protocol” & Dataset “country”,  
actually i dont want to join these two dataset because after joining there will be huge data because of that reason it will not be able to load the data.

thats is why I am dividing these datasets into two parts of dataset examples given below  
actual table  
|protocol|country|Subjects|sites|  
|1 |IN |a |2 |  
|2 |US |b |3 |  
|3 |AR |c |4 |  
|4 |DB |d |5 |

because of the issue I am dividing into two dataset

I am taking protocol & country in one dataset  
|protocol|country|  
|1 | IN |  
|2 | US |  
|3 | AR |  
|4 | DB |

in this dataset I have added one filter called “Country”

and Subject & site in one dataset  
|Subjects|sites|  
|a | 2 |  
|b | 3 |  
|c | 4 |  
|d | 5|

these dataset doesn’t have any filter.

now using these two dataset without any join i will add two dataset to the report separately

first table i will create using first dataset with filter country  
second table i will create using second dataset with no filter

now the requirement is,  
from first dataset filter country if i select a value “IN”  
then it should filter in both table which is coming from different dataset

expected output after filtering country  
first table from first dataset  
|protocol|country|  
|1 | IN |

second table from second dataset  
|Subjects|sites|  
| a |2 |

these results you can compare it with the actual table given above

is there a way to achieve this without joining these two datasets?

please help me with this thank you in advance for helping me out.

Thanks & Regards,  
Deepak Kumar Pradhan

---

<div class="post-metadata">

**Author:** ![Deep](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/deep/32/14783_2.png) [@Deep](https://community.amazonquick.com/u/Deep)\
**Post date:** [February 21, 2024, 10:11am UTC](https://community.amazonquick.com/t/two-dataset-working-together-without-doing-any-joins/26196/2 "2024-02-21T10:11:33Z")

</div>

Hello Deepak,

you may refer to this blog post. look for **Use case 2: filtering across multiple data sets**

> **[Using QuickSight parameters and controls to drive interactivity in your...](https://aws.amazon.com/blogs/big-data/using-quicksight-parameters-and-controls-to-drive-interactivity-in-your-dashboards/)**
>
> Amazon QuickSight added support for parameters, on-screen controls, and URL actions earlier this year. In this blog post, we walk through several examples to show how you can use these capabilities within interactive dashboards for your audience.

Hopefully this might be helpful.

Thank you.  
Cheers,  
Deep

---

<div class="post-metadata">

**Author:** ![Deepak1](https://avatars.discourse-cdn.com/v4/letter/d/8dc957/32.png) [@Deepak1](https://community.amazonquick.com/u/Deepak1)\
**Post date:** [February 21, 2024, 10:44am UTC](https://community.amazonquick.com/t/two-dataset-working-together-without-doing-any-joins/26196/3 "2024-02-21T10:44:18Z")

</div>

Hello Deep,

Hope you are doing well,  
Thank you for the quick response.

The solution that you have provided it works when both the dataset has same column like in my case country column.

but my issue is country column is not there in both the dataset only for the first dataset it is there so in that case your solution will not work.

is there any other solution ?

Thanks & Regards,  
Deepak Kumar Pradhan

---

<div class="post-metadata">

**Author:** ![Deep](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/deep/32/14783_2.png) [@Deep](https://community.amazonquick.com/u/Deep)\
**Post date:** [February 21, 2024, 11:28am UTC](https://community.amazonquick.com/t/two-dataset-working-together-without-doing-any-joins/26196/4 "2024-02-21T11:28:43Z")

</div>

Hello Deepak,

The main concern you have is related to the volume, what numbers are we talking about here?  
how much data are your expecting to grow and what is the concern data source here?

May be you need to adjust and fix the issue in the source or staging source itself rather than in the visuals.

Thank you.  
Cheers,  
Deep

---

<div class="post-metadata">

**Author:** ![Deepak1](https://avatars.discourse-cdn.com/v4/letter/d/8dc957/32.png) [@Deepak1](https://community.amazonquick.com/u/Deepak1)\
**Post date:** [February 21, 2024, 11:59am UTC](https://community.amazonquick.com/t/two-dataset-working-together-without-doing-any-joins/26196/5 "2024-02-21T11:59:02Z")

</div>

Hello Deep,

thank you for your help and suggestion.  
Have a great day ahead.

Thanks & Regards,  
Deepak Kumar Pradhan