topic Re: Combining Spreadsheets in Alteryx Designer Desktop Discussions

Combining Spreadsheets

NBPSE — Sun, 27 Jul 2025 17:48:20 GMT

I'd like to combine 2 spreadsheets. The first spreadsheet is a much larger full and complete list of data. The second spreadsheet is a summed list. What is the best way to combine spreadsheet 2 to spreadsheet 1. What I need to do is combine the second spreadsheet with the first, grouping the summed amounts on the second spreadsheet to the largest subsection in the first. For example, Spreadsheet 2 apples need to be combined with the Gala apples in spreadsheet 1 because that is the highest total weight in the first spreadsheet for the Apples grouping.

Spreadsheet 1

Apples

Gala - 5 pounds

Cosmic 3 pounds

Red - 2 pounds

Bananas

Yellow - 4 pounds

Green - 2 pounds

Spreadsheet 2

Apple - 2 pounds (should combine with Gala Apples)

Banana - 1 pound (should combine with Yellow bananas)

Re: Combining Spreadsheets

abacon — Sun, 27 Jul 2025 23:47:16 GMT

@NBPSE Is there a specific identifier that details why the apples in spreadsheet 2 should go with Gala? Without seeing the data I would say to do a join but without having a specific key to join on, it's hard to fully help.

Are you able to post the full dataset or a test dataset that is similar so we can help further?

Bacon

Re: Combining Spreadsheets

Gaurav_Dhama_ — Mon, 28 Jul 2025 05:15:23 GMT

Based on the available information, I would find the max pound per fruit, then join it with the fruit type in second spread sheet. Attached is a workflow which gives result as mentioned.

Re: Combining Spreadsheets

NBPSE — Tue, 29 Jul 2025 00:05:27 GMT

This works, thank you!