How to combine files with the same columns; append rows

[dewoods17]

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!

[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?

[fmvizcaino]

Hi @dewoods17 ,

By configuring your input data tool with the *, the tool will upload all the files concatenated as desired. There is no need to configurate anything else 🙂

Best,

Fernando Vizcaino

[dewoods17]

Thank you for your help. I added in the " * " but i may still be doing something wrong. Do I need to do anything further to prompt the files to load? 

[fmvizcaino · Accepted solution]

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

[dewoods17]

Okay I finally got it thank you!! Last question, Is there a limit to the number of rows that be combined? 

[fmvizcaino]

No, there isn't! 😄

[Henrytabares]

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

Henry

[fmvizcaino]

Glad to help @Henrytabares ! 😁