community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Need to get weekends

Meteor

Hi all,

As a continutation of my previous thread:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Handle-the-missing-dates/m-p/336838

 

I need to separate the weekends for each person separately as weekend in the column type.

Any body help in this!!!

 

Regards,

Yoganantha Prakash G P

Alteryx
Alteryx

Hello,

 

Can write an If statement in a formula tool?

 

*Add Column*

 

IF

Day="Saturday" OR Day="Sunday"

THEN

"Weekend"

Else 

"Weekday"

ENDIF

 

Then a simple filter on your new column should suffice.

 

Nick

Labels