This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Don't forget to register for our panel discussion with Dean Stoecker, Amy Holland, and Mark Frisch occurring next Wednesday, June 1!
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.
Go to Solution.
Go to Solution.
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.
Population (I mean volume of xls files) can be different for the further... So, What about getting name of xls file to one output?
@Gorkemmizrak the below post will able to help your requirement
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.