How to Load Multiple Files in QS and Have Dynamic View based on Columns in Each File?

Hello,
I am working on developing a report that draws from multiple S3 files, the files output a metric on difference segments for experimentation. As each file can have different segments it will have difference column counts. Is there a way to allow the user to select which file they want to view and then dynamically create the view showing the data? I don’t intend to calculate anything I want to use QS as a UI mechanism.

Is there any current way to do so?

Hi @noraalsh and welcome to the QuickSight community!
QuickSight does not allow you to build visuals that contain fields from multiple datasets. But there are some work around options depending on the scenario and your datasets.

One option would be to join your datasets. This can be done if your datasets have at least 1 field that is identical across the datasets. This would be the only way to incorporate data from multiple datasets in one visual.

Another option you could explore though without joining tables would be to create a visual for each dataset and then show/hide them based on a parameter selection that allows the user to select a file.

For this option (which would need to utilize a free-form page layout), start by building a visual for each of your datasets with the information you’d like them to contain.
Then, build a parameter with custom values. These values can be whatever makes the most sense for the user:


Once you have the parameter set up, then you can add Rules to each visual (located in the format visual screen). Start by switching the box to ‘hide the visual by default’, then add your rule:

Setup a rule for each visual and change the ‘Value’ in the rule to match your parameter option.

Last step, you can then ‘layer’ the visuals on top of each other so that your dashboard view makes it look like it’s only one visual. And make sure to ‘hide’ your background for each visual so that when they are hidden, you can see the next visual behind it.

Let me know if this works for your case or if you have any additional questions.

Hi @noraalsh,
Following up here as it’s been awhile since we last heard from you; did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you

Hi @noraalsh,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.

Thank you!