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.
I have used Cache Dataset V2 macro for the first time and I am not sure if I am missing something out. I have implemented everything that's written in this article by @MacRohttp://community.alteryx.com/t5/Engine-Works-Blog/The-Cache-Dataset-Macro/ba-p/3162. As you can see the in the image below, when I click on the 'Select' tool, columns don't show up. There are more than 30 columns in my dataset. When I run it again, they show up but there is no consistency. I am not sure what's going on. Can anyone help with this? Thank you.
Hi @sagarb, unfortunately this is a known bug that has not yet been resolved. My recommendation would be to use the original Cache Dataset macro (available for download on the Gallery here). It doesn't have all the bells and whistles of Cache Dataset V2, but it does exactly what you are looking for (field metadata consistently passing through to downstream tools) and is very reliable. I'm sorry V2 didn't work out for you, but hope this helps!
The issue is when a tool inside a disabled container is connected to a macro. This goofs up the metadata. This is usually how the cache macro is setup when you're using read mode. I've submitted it to Alteryx via their support channels, but I'm not sure that anything will come of it.
For version 1, you would just have to delete the incoming connection to macro and the metadata was again working for me.
For version 2, you would still need to delete the incoming connection; however, you need to make one small change to the macro, and I would recommend a second change. Insert the macro onto the canvas of a workflow. Right click the macro and click open macro. Go to the properties section (wrench icon) of the interface designer (View >>> Interface Designer). Check the box that says output fields change. Save the macro. This will assist with metadata issues.
If you ever use the advanced option about suppressing the read mode notification error, my recommended change would be to make the macro input optional by checking the optional box.