Combining similar Fields from multiple excel files

Hello Guys,

I am new to the Alteryx. I am looking to combine data from multiple excel files. See Images below. I am basically want to combine Data 1 and Data 2 to get a result same as Combined DATA 1 & 2.

DATA 1 DATA 2

DATA 1.jpg DATA 2.jpg

Combined DATA 1 & 2

Combined DATA 1 & 2.jpg

Thanks in advance!

Varinder Singh

Common Use Cases

Accepted answers

SeanAdams

Hey @varindersra

There are 2 parts to your question:

a) How do I read multiple excels at once

b) how do I stitch them together into 1 table.

a) reading multiple Excels

This is where Alteryx is FANTASTIC - if you use the input tool, and instead of picking 1 specific excel file, you can use a wildcard (for example *.xlsx). What Alteryx does then is to read every one of the excel files, and pulls them into one stream.

b) stitching them into 1 table

I've attached a workflow for you - and depending on whether you want this oriented by row or by column you can use either of the two outputs I've provided.

The transpose and cross-tab tools are tremendously powerful, and allow you to do a huge amount of data-restructuring very quickly - well worth learning these tools, and this may be an easy way to start playing.

If this answers your question - would you mind marking this as solved? If you still have doubts or questions - feel free to reply to this thread with any additions or updates to the workflow attached, and with your open / remaining questions.

Cheers @varindersra

Sean

New Alteryx Workflow.yxmd

All comments

Bob_Blackey

Hi Varinder,

Welcome to the wonderful world of Alteryx.

You want to use the JOIN tool to get what you need. You would JOIN on the FIELDS column. Note that in your output you cannot have two fields with the same name.

Bob_Blackey

Hi Varinder,

Welcome to the wonderful world of Alteryx.

You want to use the JOIN tool to get what you need. You would JOIN on the FIELDS column. Note that in your output you cannot have two fields with the same name (DATA). Within the JOIN tool you can rename one of the fields.

There are quite a few resources available to help you learn how Alteryx works. The Alteryx website has a training section with short videos which I'd review. Also in Alteryx under the menu:

Help | Sample Workflows | Tutorials | Blending Data

there is an example of a join. I would review all the tutorials and as many of the other samples as you can. The best way to learn is do.

Cheers,
Bob

SeanAdams

Hey @varindersra

There are 2 parts to your question:

a) How do I read multiple excels at once

b) how do I stitch them together into 1 table.

a) reading multiple Excels

b) stitching them into 1 table

I've attached a workflow for you - and depending on whether you want this oriented by row or by column you can use either of the two outputs I've provided.

Cheers @varindersra

Sean

New Alteryx Workflow.yxmd

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167