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.
Thanks a lot for your suggestion. I learnt a lot from the link.
However, I feel my need is somewhat different. I have a alteryx model that read through multiple sheets of an excel and picks up the necessary data.
I have used many tools like picking the first 8 rows, etc.
I am trying to achieve the same for 10 other excel spreadsheets but unfortunately they have slightly different schema. If I try to follow the method mentioned below, all the sheets are read together and the values are combined, instead of executing the alteryx workflow entirely for each excel spreadsheet.
Is there a way to solve this? It is more like a loop where alteryx model is expected to execute for each excel. Kindly let me know if we have a solution.
I do believe that we can accomplish what you are trying to get at here. I also think it will follow the same method mentioned in the article posted by @atcodedog05 above. I believe the path you will have to go down is creating a Batch Macro route.This process will look like the following example attached.
In this process you will feed in a list of files and sheet names. Then use the Batch Macro to read in sheet by sheet separately. The beneficial thing about going the batch macro route is you get the ability to configure how the sheets are combined after reading them in. This is down within the interface designer (View -> Interface Designer).
Hopefully this points you in the right direction. If you have any questions please ask.
Hey @Sangs, If you try to open the .yxzp. This should create a folder that contains the data for the workflow as well as the workflow itself as the .yxmd. To change the version so you can open it simply open the .yxmd in notepad and change the version history at the top from 2021.2 to 2019.2. See photos below.