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.
Hi, I'm very new to Alteryx and I was hoping for some guidance on how to complete this task.
I have a folder of files, all the same structure (Year1.xlsx, Year2.xlsx, Year3.xlsx for example purposes). Each of the files has sheets related to different stores (A,B,C,D,E). I'd like to go through each of the files and grab the yearly revenue from each of the stores (in the Year _ column) and create a master sheet for each store in the Expected Result.xlsx.