Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED
Hi,
I have been trying to figure this out but no luck. I have date in the date timer format. I parse the time out to a separate column and i am trying to write a formula that says if the time is after 17:30 and terminal type is onsite then classify as night shift, else if time is before 17:30 and terminal type is onsite then day shift else 0. But i am getting an error. Is this possible?
Solved! Go to Solution.
Hi @krishnagandhi, I put together a simple solution to help demonstrate your solution.
I convert the DateTime field to just Time and then write a formula to identify Shifts
Let us know if this works on your larger dataset.
