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.
Find answers, ask questions, and share expertise about Alteryx Designer.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
If I used a macro, to pull all of the tables on each tab is there a way that alteryx would store it efficiently for use?
For example rather than collect the grand total I wanted to collect and store the tables on each tab and then I wanted it all saved by the file name. (Bearing in mind that I am going to keep received files in the exact format).
How would alteryx store tabular data from different pages.
It depends on your intention storing the individual sheets. I built a sample macro that you can experiment with depending on your intention. If you want to save the individual sheets as yxdb files, the batch macro can help with that. If you just want to read all the sheets on top of each other (and they all have the same schema), the dynamic input will be enough.
I hope this helps!
you can also experiment with output configurationsmacro workflow