Don't forget to register for our panel discussion with Dean Stoecker, Amy Holland, and Mark Frisch occurring next Wednesday, June 1!

2022-05-26 Updates: Email: If you're not seeing emails be delivered from the Community, please check your spam and mark the Community emails as not junk. Thank you for your patience.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

How to get datas from multiple identical excel files to one output?

Gorkemmizrak
6 - Meteoroid

Hello everyone,

 

I have 75 xls files which are in same format but has different values. I just want to combine files name of these xls file to one output and get spesific colum value of them to another one output?

 

Is there a easier way to do that? I do not want to create 75 different input tools and perform it.

 

I do not have a chance to share the data because of confidentiality.

 

Thanks in advance.

 

 

4 REPLIES 4
Pingu
9 - Comet

Is it a one time thing or will the folder populate with more .xls files over time (and thus needing a dynamic input).

 

If not. Then you can do it really quickly manually. Just select the files in the folder and drag and drop them in the alteryx canvas. 

As the files are in the same format but different values you can drop an union tool and right click on it and click 'show possible connections'.

This way you can just tick the boxes and not have to draw 75 lines.

Gorkemmizrak
6 - Meteoroid

Population (I mean volume of xls files) can be different for the further... So, What about getting name of xls file to one output?

binuacs
15 - Aurora
Pingu
9 - Comet

Its hard to show without some mockup .xlsx files in a folder.

 

1. Use a directory tool and specify the directory .\ and file specification *.xls(x)

2. Use Dynamic Input tool. Field: FullPath, Action: change entire file path.

3. Add browse tool.

4. You might need to add some filter or different tool to filter out duplicate headers if this is applicable.

Labels