days conversion

[Deepakdw]

Hi All, Learning alteryx eagerly but got some easy doubts that are stuck in my head can you help me solve How to convert days i.e monday, tueday....friday to weekday and saturday and sunday as weekend.

[ydmuley · Accepted solution]

Hello @Deepakdw 

You can use the function in DateTime tool to arrive at the day - Monday, Tuesday, etc.

Later you can use Formula tool to put a condition:

IF [Day] = 'Sunday' OR [Day] = 'Saturday' THEN 'Weekend' ELSE 'Weekday' ENDIF

Regards,

Yug

[Deepakdw]

Thanks to both of you, solved it with ease. 🙂