How to combine files with the same columns; append rows

Hello. I am using large data files that each have multiple years of data in them and would like to combine them. They all have the same columns, and I would like to be able to combine them into one file. Can someone help me? I have examples attached. Examples 1 and 2 represent how the two history files I am using have the same columns and I would like to make the file look like Example 3, all data combined.

thank you!

Example 1.xlsx

Example 3.xlsx

Example 2.xlsx

Connectors

Accepted answers

fmvizcaino

Hi @dewoods17 ,

No, that is it! Insert a browse tool after and run your workflow to check that you have all files included in your output.

When you use the * in your filename, the preview stop working, but the output anchor brings all data.

Best,

Fernando Vizcaino

All comments

fmvizcaino

Hi @dewoods17 ,

The only thing you need to do is to configure your input data tool to read them all. Be careful that your input tool will read all files that starts with 'Example', so you need to guarantee there is no other files with the same prefix.

Best,

Fernando V.

dewoods17

okay, and what connection do i use to combine them?

Henrytabares

Fernando, Just to confirm that this made my day... Thank you!!!

Henry

fmvizcaino

Glad to help @Henrytabares ! 😁

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335