Merge two excel tables vertically

I have 2 larger 120-300mb reports aprox 600k-900k rows. I am trying to stack them to use the pivot sort function and aggregate data in analysis. Quicksight wants to join by inner outer etc. Is this possible?
–*

Hi @roleson, yes, it’s possible. Joining data is done at the dataset, here is the details.

data-prep-open-join-configuration

We hope this solution worked for you. Let us know if this is resolved. And if it is, please help the community by marking this answer as a “Solution.” (click the check box under the reply)

Hi @roleson - Welcome to AWS QuickSight community. If you have a common key in 2 excels, you can always upload the 2 excels and do a join ( depending upon requirements) as stated by @Xclipse and get the desired result. Please see the join documentation of QuickSight below.

Regards - Sanjeeb