I created a dataset by uploading my own excel file to which I correctly applied Q. I wanted to know if it was possible to create a dataset that draws from an excel with multiple sheets and if Q has a chance of being successfully applied to it and in the specific case if the queries entered by the user are answered by Q drawing from info from all the sheets in the excel (dataset)
Hello @iovinof, welcome to the QuickSight Community!
I would say you have 2 options. If your excel sheets have a matching column value, like UUID, you could join each of them together in QuickSight so they will function as a singular dataset.
On your initial dataset made from Sheet1, you click the Add data button. Either import all sheets as individual datasets before this step or import them during your joins from the excel file. Then once it has been added, click the 2 dots and run a join based on the matching value. You can exclude the duplicated column from the dataset in your field mapping. Now Q should be able to query it as a single dataset.
Otherwise, you can import each sheet as individual datasets and then have Q draw information from them individually.
I will mark this as a solution for now, but if you have any further questions please let me know! I will also include a screenshot of what that join would look like below:
