{"id":515084,"date":"2018-10-03T13:00:00","date_gmt":"2018-10-03T11:00:00","guid":{"rendered":"https:\/\/www.devoteam.com\/expert-view\/cache-data\/"},"modified":"2018-10-03T13:00:00","modified_gmt":"2018-10-03T11:00:00","slug":"cache-data","status":"publish","type":"expert-view","link":"https:\/\/devoteam.info\/me\/expert-view\/cache-data\/","title":{"rendered":"Cache data with Alteryx: Save time when running large workflows"},"content":{"rendered":"\n

At Inviso<\/strong>, we know that time is cache<\/em>, which means running time-consuming workflows in Alteryx can be costly when you need to get things done before a deadline. But worry not! In this blog I will teach you a very effective and very simple way of limiting the time you spend running your workflows. No more (than once) shall you spend time pointlessly running time-consuming workflows when you just need to test a single tool.<\/p>\n\n\n\n

Caching data by creating a temporary file:<\/strong><\/p>\n\n\n\n

In the 2018.2 version (and newer) there is a built in Cache functionality that allows you to run only a subset of your tools in your workflow by creating a temp file from the data at a given point in your workflow. To do this, right click on the tool with the data you want to cache and press the Cache and Run workflow button.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Having done this, Alteryx creates bubbles around the tools to indicate that data has been cached:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n


<\/a><\/p>\n\n\n\n

If you want to disable the cache function, right click the arrow (in the select tool) and press clear cache.<\/p>\n\n\n\n

Cacheing data using previous versions of Alteryx<\/strong><\/p>\n\n\n\n

For pre-2018.2 users of Alteryx, you can use the built-in cache tool called Cache Dataset V2. The idea is to store the time consuming tools in a tool-container and then have the Cache Dataset macro outside the tool-container. You then run the workflow once and disable the tool-container. The Cache macro will then have stored a temporary file. After running the workflow once, you need to change the configuration of the Cache tool to “read from temp file”. Alteryx will then continue using the data in the temp file the next time you run the workflow.
The GIF below shows you how it’s done.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Notice in the GIF that the error-message is not actually an error, but an indicator of which mode<\/em> the macro is on.<\/p>\n\n\n\n

Have fun spending (maybe a little less) time working with Alteryx!<\/p>\n","protected":false},"excerpt":{"rendered":"

At Inviso, we know that time is cache, which means running time-consuming workflows in Alteryx can be costly when you need to get things done before a deadline. But worry not! In this blog I will teach you a very effective and very simple way of limiting the time you spend running your workflows. No more (than […]<\/p>\n","protected":false},"featured_media":515086,"template":"","categories":[],"tags":[3508,2302,3500],"industry":[],"class_list":["post-515084","expert-view","type-expert-view","status-publish","has-post-thumbnail","hentry","tag-alteryx-me","tag-data-me","tag-denmark-me"],"acf":[],"cards":"\n\t

\n\n\t\t
\"Cache<\/a><\/figure>\n\n\t\t\n\t\t
\n\t

Expert View<\/p>\n\n\t\t\n\t\t

Cache data with Alteryx: Save time when running large workflows<\/a><\/h3><\/div>\n\t\t\n\t<\/div>\n\n","yoast_head":"\nCache data with Alteryx: Save time when running large workflows | Devoteam<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/devoteam.info\/me\/expert-view\/cache-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cache data with Alteryx: Save time when running large workflows\" \/>\n<meta property=\"og:description\" content=\"At Inviso, we know that time is cache, which means running time-consuming workflows in Alteryx can be costly when you need to get things done before a deadline. But worry not! In this blog I will teach you a very effective and very simple way of limiting the time you spend running your workflows. No more (than […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/devoteam.info\/me\/expert-view\/cache-data\/\" \/>\n<meta property=\"og:site_name\" content=\"Devoteam\" \/>\n<meta property=\"og:image\" content=\"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/ZG3jlPk.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/devoteam.info\\\/me\\\/expert-view\\\/cache-data\\\/\",\"url\":\"https:\\\/\\\/devoteam.info\\\/me\\\/expert-view\\\/cache-data\\\/\",\"name\":\"Cache data with Alteryx: Save time when running large workflows | Devoteam\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/devoteam.info\\\/me\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/devoteam.info\\\/me\\\/expert-view\\\/cache-data\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/devoteam.info\\\/me\\\/expert-view\\\/cache-data\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/devoteam.info\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/shutterstock_1658419111-scaled-2.jpg\",\"datePublished\":\"2018-10-03T11:00:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/devoteam.info\\\/me\\\/expert-view\\\/cache-data\\\/#breadcrumb\"},\"inLanguage\":\"en-SA\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/devoteam.info\\\/me\\\/expert-view\\\/cache-data\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-SA\",\"@id\":\"https:\\\/\\\/devoteam.info\\\/me\\\/expert-view\\\/cache-data\\\/#primaryimage\",\"url\":\"https:\\\/\\\/devoteam.info\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/shutterstock_1658419111-scaled-2.jpg\",\"contentUrl\":\"https:\\\/\\\/devoteam.info\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/shutterstock_1658419111-scaled-2.jpg\",\"width\":1920,\"height\":763},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/devoteam.info\\\/me\\\/expert-view\\\/cache-data\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/devoteam.info\\\/me\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Expert View\",\"item\":\"https:\\\/\\\/devoteam.info\\\/me\\\/expert-view\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Cache data with Alteryx: Save time when running large workflows\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/devoteam.info\\\/me\\\/#website\",\"url\":\"https:\\\/\\\/devoteam.info\\\/me\\\/\",\"name\":\"Devoteam\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/devoteam.info\\\/me\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-SA\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Cache data with Alteryx: Save time when running large workflows | Devoteam","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/devoteam.info\/me\/expert-view\/cache-data\/","og_locale":"en_US","og_type":"article","og_title":"Cache data with Alteryx: Save time when running large workflows","og_description":"At Inviso, we know that time is cache, which means running time-consuming workflows in Alteryx can be costly when you need to get things done before a deadline. But worry not! In this blog I will teach you a very effective and very simple way of limiting the time you spend running your workflows. No more (than […]","og_url":"https:\/\/devoteam.info\/me\/expert-view\/cache-data\/","og_site_name":"Devoteam","og_image":[{"url":"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/ZG3jlPk.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/devoteam.info\/me\/expert-view\/cache-data\/","url":"https:\/\/devoteam.info\/me\/expert-view\/cache-data\/","name":"Cache data with Alteryx: Save time when running large workflows | Devoteam","isPartOf":{"@id":"https:\/\/devoteam.info\/me\/#website"},"primaryImageOfPage":{"@id":"https:\/\/devoteam.info\/me\/expert-view\/cache-data\/#primaryimage"},"image":{"@id":"https:\/\/devoteam.info\/me\/expert-view\/cache-data\/#primaryimage"},"thumbnailUrl":"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/shutterstock_1658419111-scaled-2.jpg","datePublished":"2018-10-03T11:00:00+00:00","breadcrumb":{"@id":"https:\/\/devoteam.info\/me\/expert-view\/cache-data\/#breadcrumb"},"inLanguage":"en-SA","potentialAction":[{"@type":"ReadAction","target":["https:\/\/devoteam.info\/me\/expert-view\/cache-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-SA","@id":"https:\/\/devoteam.info\/me\/expert-view\/cache-data\/#primaryimage","url":"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/shutterstock_1658419111-scaled-2.jpg","contentUrl":"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/shutterstock_1658419111-scaled-2.jpg","width":1920,"height":763},{"@type":"BreadcrumbList","@id":"https:\/\/devoteam.info\/me\/expert-view\/cache-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/devoteam.info\/me\/"},{"@type":"ListItem","position":2,"name":"Expert View","item":"https:\/\/devoteam.info\/me\/expert-view\/"},{"@type":"ListItem","position":3,"name":"Cache data with Alteryx: Save time when running large workflows"}]},{"@type":"WebSite","@id":"https:\/\/devoteam.info\/me\/#website","url":"https:\/\/devoteam.info\/me\/","name":"Devoteam","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/devoteam.info\/me\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-SA"}]}},"uagb_featured_image_src":{"full":["https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/shutterstock_1658419111-scaled-2.jpg",1920,763,false],"thumbnail":["https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/shutterstock_1658419111-scaled-2-150x150.jpg",150,150,true],"medium":["https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/shutterstock_1658419111-scaled-2-300x119.jpg",300,119,true],"medium_large":["https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/shutterstock_1658419111-scaled-2-768x305.jpg",768,305,true],"large":["https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/shutterstock_1658419111-scaled-2-1024x407.jpg",1024,407,true],"1536x1536":["https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/shutterstock_1658419111-scaled-2-1536x610.jpg",1536,610,true],"2048x2048":["https:\/\/devoteam.info\/wp-content\/uploads\/2024\/11\/shutterstock_1658419111-scaled-2-2048x814.jpg",2048,814,true]},"uagb_author_info":{"display_name":"Julien Pawlowski","author_link":"https:\/\/devoteam.info\/me\/author\/"},"uagb_comment_info":0,"uagb_excerpt":"At Inviso, we know that time is cache, which means running time-consuming workflows in Alteryx can be costly when you need to get things done before a deadline. But worry not! In this blog I will teach you a very effective and very simple way of limiting the time you spend running your workflows. No more (than…","_links":{"self":[{"href":"https:\/\/devoteam.info\/me\/wp-json\/wp\/v2\/expert-view\/515084","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devoteam.info\/me\/wp-json\/wp\/v2\/expert-view"}],"about":[{"href":"https:\/\/devoteam.info\/me\/wp-json\/wp\/v2\/types\/expert-view"}],"version-history":[{"count":0,"href":"https:\/\/devoteam.info\/me\/wp-json\/wp\/v2\/expert-view\/515084\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devoteam.info\/me\/wp-json\/wp\/v2\/media\/515086"}],"wp:attachment":[{"href":"https:\/\/devoteam.info\/me\/wp-json\/wp\/v2\/media?parent=515084"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devoteam.info\/me\/wp-json\/wp\/v2\/categories?post=515084"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devoteam.info\/me\/wp-json\/wp\/v2\/tags?post=515084"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/devoteam.info\/me\/wp-json\/wp\/v2\/industry?post=515084"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}