Filter by day and time for appending data

Question

Hi all!

The requirement is to append data so we are able to compare current vs week. The workflow for this one is scheduled to run every hour daily. Ang for this specific container we only wanted to get the output every Monday at 8 AM. Is there a way to use the filter tool for that case? Thank you!

chuckleswk · Answer

You might find this useful:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Radio-button-enable-disable-container/m-p/453108/highlight/true#M87747

I have used this method and had an input that gave me the day of the week and the time. I then pass that through a formula tool and say that if the day = monday and the time = 08:00 then 1 else 0. I then use that variable and pass it into the macro and use that to enable or disable the container with the output tool. Mind you, the output flow will have to be in a Macro or this method won't work.