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 new to alteryx and need your help and support to see how can I use it correctly.
I have an excel template with multiple tables in multiple tabs. I also have hundreds of users which each complete a copy of the template.
What I need is to combine all these excel spread sheets with information provided by the users into one main data file. Attach is the example of my template. To make it simple this one has two tabs, one is the example of input table (which users complete) and the other tab is an example I am looking to get it as my output by using alteryx.
That looks it would work, the 2 problems I see is:
1) Do the number of rows change ?
2) when you write to the main data file, what is that and do you want to add to it over time ?
If all the spreadsheets are the same layout, you could write a macro and then then all the sheets using the same macro. This could be as easy as putting all the files in a single directory and then the workflow processes all files in that directory.
Within each workbook, do the tabs have the same schema?
In other words, should File 1.Sheet1, File1.Sheet2, File1.Sheet3, File2.Sheet1, File2.Sheet2, File3.Sheet3 all be blended into one data source? Do the different sheets in each workbook represent different organizations? Or should all sheet1's be unioned, all sheet2's, etc.
I have a macro worked up, just need to figure out how to implement it for you based on your needs.