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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

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