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.
Thank you for your help! I am still having trouble with this. Here are some example records. I want to mimic column E calculating the net working days between for each record just like Excel does. I don't care about Holidays.
How would I get that batch macro to run for each record?
I made some changes to the macro that eliminates reference to holidays and will capture the other data from your records. The output from the macro is labeled "Count". You can rename with a Select tool.
RodL, I'm having trouble downloading the most recent module you attached. I downloaded and can execute the first one without any trouble. When I try to extract the last one, I get the error "This document was created by a more recent version of this application and cannot be read." I've doublechecked that I have the most current version of Alteryx on my pc (ver 10.1.6.60263). Any idea why I might be having this trouble?
MitchellG, When I click the download link on yours a page opens up with the .xml code but it doesn't give me the option to open in Alteryx or save as a file. Could be something with my firewall, I suppose.
I would like to extend it further to check holidays on different states. I tried bringing in another Control Parameter in the macro which will identify a state. But I could not get this working. What would be the best approach?