Good morning Alteryx community,
I am wanting to only pull certain dates. I am building two reports within my one Alteryx flow. The first report I only want Feb 2019 through Jan 2020. The the next report Feb 2020 to present. What formula do I put in the filter tool to get those results?
Thank you
Solved! Go to Solution.
@Plewis1 ,
Hi! Thanks for the post. I'm using it for a youtube opportunity to answer the community. We've answered your post with a skeleton workflow to demonstrate the separation of a single source of data into two processes within one workflow. Please check it out!!!
Cheers,
Mark
@Plewis1 ,
As @Thableaus requested, you replied with a YXMD file. Unfortunately, it doesn't include the real data. None the less I do think that the approach given in my skeleton will work for you. I was pleased to see your filters and how you used the datetimediff() function. It is consistent with our solution. You only need to read the input file once and you can use the last filter for separating the data.
Cheers,
Mark
P.S. If you ever want to export real data, please use OPTION -> Export Workflow and check the boxes for your inputs.
I'm sorry, but I don't get the skeleton flow. I see how to start it from a certain date but I'm not seeing how to stop it at a certain date. Then proceed again from a certain date which would be in a different sheet. Is there an actual formula for that?
Thank you very much Mark for reaching out to me. It shows the care you have to help others grow within the Alteryx community. You have showed me how to simplify my flow which in turn saves time. Now I understand how to use certain dates and having them outputted using the True and False functions within the filter tools. Here is the example we used to achieve that goal.
Thank you Mark.
Thanks for the contribution and the opportunity for me to help not only you, but hopefully others too. I am attaching links to my YouTube videos on your post. Anyone giving likes or subscribing will be doing me a favor by doing so.
Cheers,
Mark