Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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.
