I hope this message finds you well. I’m currently working on a project in Amazon QuickSight where I need to join multiple datasets and create a resultant for further analysis. Here’s a breakdown of what I’ve done and the challenge I’m facing:
Data Joining Process:
I have joined Dataset A with Dataset C in one dataset.
Separately, I joined Dataset B with Dataset C in another dataset.
Finally, I combined these two datasets to analyze the integrated data.
2.Requirement:
I need to replicate this final joined dataset to perform additional analysis and visualization tasks.
Encountered Issue:
However, when attempting to create a replica of the final dataset, I encountered an error stating that “more than 3 levels of child datasets cannot be created.”
Could someone please provide guidance on how to achieve the following in QuickSight?
Effectively joining Dataset A with C and Dataset B with C separately within the same analysis.
Creating a replica of the final joined dataset to facilitate further analysis.
Overcoming limitations such as the “3 levels of child datasets” restriction in QuickSight.
I would greatly appreciate any insights, examples, or references to documentation that could help me resolve this issue and optimize my data analysis workflow.
Thank you very much for your assistance!
Also previously raised same question but it got archived now and i was unable to reply for the same. All those replies cannot solve issue as we need to join 2 different datasets as the base dataset in joining.
Please refer below link for accessing open question:
Hello @Surya_Prakash, I understand you were unable to resolve the issue with the previous advice given. If you’re requirement is to join 2 different sets of datasets together, and then join them into a single dataset, you will be unable to achieve this. If you want to join them in QuickSight, you will need to join each dataset to a base level dataset.
If you start with a single dataset, you should be able to individually join 3 datasets within the edit dataset console. If this does not work for your use case, then you will be required to join datasets either using custom SQL our outside of QuickSight. If you use custom SQL to build the 2 different datasets that run the join functions, then you would be able to join them in QuickSight.
I would also recommend filing a case with AWS Support where we can dive into the details to help you further. Here are the steps to open a support case.
I know this is a work-around to the solution you are expecting, so I will also mark this as a feature-request for our support team. Thank you!
Hello @Surya_Prakash, I wanted to check in since we have not heard back from you with any follow-up questions. Please let me know if there is any further guidance I can provide you on this topic for possible work-around solution. If we do not hear back from you in 3 days, I will archive this topic for our support team. Thank you!
Hello @Surya_Prakash, since we have not heard back from you, I will close out this topic. If you require further assistance after filing a support case, please post a new question in the community and link to this topic. That will ensure you are at the top of the priority list for a response from one of our QuickSight experts. Thank you!