How to Get the Excel files in a Folder

[MostafaBouzari]

Hello everyone,

i'm Totally new to Alteryx so i'm sorry if my question is entery level.

i want to make an App that

1)gets different excel files with different rows and coloumns 

2)Files are in the same Directory or Folder

Thank's in Advance

[afv2688 · Accepted solution]

Hello @MostafaBouzari,

Welcome to the community! What is the relationship between the files? The columns have different data associated? Are the columns in the same position but do they have different names only?

What you want to achieve is definetly possible using tools like directory or dynamic input, but I need more information to give you a solution.

You can also check the macro I leave you here and explore it and see if it meets your needs

Regards

[MostafaBouzari]

They are different Years of data from a company.for example sales and product. and in fact i want to do a Union afterwards.

but my problem right now is how to do it and your sample gives some errors.

Is there Something that i need to do befor Running?

[zakellaoui]

Hello Mustapha, 

You can simply use the input tool.

One question so I can better help you : Do your files have the same format (Number of columns)

Best, 

Zakaria

[MostafaBouzari]

they have the same Format(coloumns)

[zakellaoui]

Then use an "input tool" and change this line, keep the folder, but change the name of your excel to "*". 

By adding a *, it will load all your files at once. 

If this solution works, please mark it as "accepted solution" so that other can benefit from this tips 🙂 

[MostafaBouzari]

Thanks for your reply.

i want users select the files not me(it should be an app)

[zakellaoui]

Oh my bad, I missed the app part. 

So if you want your users to choose the files, 

You need to add in workflow : 

1. interface tools : File browser tool 

2. Action tool  : that you connect to your input tool 

Make sure your action tool is on "update values"

Here an example of the full workflow 

full workflow attached

Was that helpful ? 

Best, 

Zak

[MostafaBouzari]

can i use this micro in Alteryx Galery? There was a Folder Brows tool inside of the Micro changed that.

Or is there sth that i might consider before uploading?

[afv2688]

This macro uses a visual basic code. Do you have office installed on the gallery or any visual basic tool?

Regards