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 a query based on a sort of 'man walks into a bar' scenario, I only have basic skills (at best) with Alteryx so have been scratching my noggin for a few days trying to work this out, I'm hoping the Alteryx Community can save the day (and my sanity!)
My dataset gives me an arrival date & time and a leaving date & time but I need to establish how many people were 'in the bar' at 8am of each day, this is the simpler part of my query, the confusion comes when people leave 'the bar' a few days later (lets assume this is a 24/7 bar :P);
So the desired outcome from this sample dataset would be along the lines of;
People in the bar at 8am
I appreciate any help or guidance you can offer me.
@LordNeilLord is spot on. The generate rows tool is the solution here. I've attached my solution. It may not be the most efficient since I'm traveling from a conference but it will get you close. Let me know if it helps.
The workflow example was a great help as I am unfamiliar with the 'Generate Rows' tool, I just made a little tweak to the 'Loop Expression' formula and added an extra column using the 'Formula' tool and was able to achieve the desired output, final workflow attached :)