Matchin excel sheets/

Hi guys,

I have a question to matching:

I have two separate excel tables, with different content but identical structur. I would like to match this two data sheets. All new data from table 2 should be added under the data from table 1. Does anybody have any ideas how can I create this workflow?

example

Table 1

Table 1.PNG

Table 2

Table 2.PNG

I would like to match data from table 1 and table 2 in one excel sheet:

My result should looks like this:

Input

Output

Accepted answers

PamW

One of my favorite changes in 10.1 is the ability to get a list of sheet names and then dynamically load all the sheets.

So you can make and union an Input Data Tool for each sheet but that might be time consuming if you have a lot of sheets.

XLSX-DynamicLoadSheets.yxzp

All comments

JohnJPS

Could you read the tables as separate inputs and then union them together.

To eliminate duplicates try a Join instead; or follow with a Unique tool.

Surname

Hi John

thanks for such fast replay. Could you please describe the process in details. I am really beginner in alteryx. Thank you!

PamW

One of my favorite changes in 10.1 is the ability to get a list of sheet names and then dynamically load all the sheets.

So you can make and union an Input Data Tool for each sheet but that might be time consuming if you have a lot of sheets.

XLSX-DynamicLoadSheets.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703