How do I combine two datasets?

I have 3 datasets: A, B, C. A contains a column called Type and it’s either B or C. Dataset B and C contains the detailed information about type B and C. All 3 datasets contain a column called id, which is shared by all three datasets.
I have a table that contains information about dataset A. When the user clicks a row with, let’s say type B and id of 1000, I want a small window or a pop-up to show the data in dataset B with id == 1000. Is there a way to do this in QuickSight?

Resolved. I fixed it by combining two datasets.

1 Like

Hi @hojungkim - Thanks, please mark your answer as solution so that it can help other community members.

Regards - Sanjeeb