What if you could “save your spot” and run only the new tools you’ve added to the canvas, without re-running everything else over and over again? Now you can with the Cache Dataset macro!
When building out a workflow that deals with large amounts of data, and/or running processor-heavy analytics, there can be a delay in iterating your workflow while you wait. With the Cache macro you can switch between reading/writing from a temporary file to continue your development efforts. Simply put upstream tools in a Tool Container and disable it, and then use the cache macro to read from the temp file to speed up developing your workflows.
To install this tool into your Alteryx toolbar, click the "Download" button above and extract the downloaded .yxzp file into your macro repository. The tool will appear in the Developer category. If you do not yet have a repository set up for saving custom macros (to have them appear in your Alteryx toolbar), follow these directions:
- From the Alteryx menu, choose Options->User Settings->Edit User Settings
- Choose the ‘Macros’ tab
- Add a search path to the folder where you extracted the macro
Read a blog about the Cache Dataset Macro
