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.
I am trying to combine information from same tab from multiple excel files. In my example, I need Alteryx to find "Analysis" tab in each excel file saved in a given directory and append information vertically. I am using directory tool and dynamic input tool. However, my output takes only one file from the directory. Why other file is not being picked up?
both files need to have the same amount of columns, named the same way and having the same data type, otherwise, those who do not share the same schema will be skipped. By the way in your case the first file has 30 columns and the second 40 and some columns don't have the same data type.
I am trying to understand your solution, that is why it is taking some time for me to reply. Unfortunately, it did not work. When I imported, first I got error message that your Alteryx has higher version and some tools might not work:
I clicked on yes and got this:
I assume that the first question mark relates to Import Multiple Schema files and the second one relates to Dynamic Multi File Macro. When i tried to update them with my directory and 2 excel files, nothing worked.