Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Getting a date from the day of the week

CaseyW
5 - Atom

Can't seem to find this anywhere and hoping it's possible. I have a report that provides a weekly order day, I am trying to convert this day into a date and can't seem to figure it out. All dates would be the next occurrence of the listed day.

 

 

 

LaneLocation 1Go Live CadencePO Drop DayPick DayShip Day
AnchorageD059WeeklyMONTUEWED
FifeD053WeeklyMONTUEWED
BufordD021WeeklyFRIMONTUE
BufordD0VAWeeklyFRIMONTUE
DixonD069WeeklyMONTUEWED
HammondD0VZWeeklyMONTUEWED
HammondD043WeeklyMONTUEWED
MontgomeryD0V2WeeklyMONTUEWED
MontgomeryD0OCWeeklyMONTUEWED
HonoluluD055WeeklyMONTUEWED
OntarioD073WeeklyMONTUEWED
OntarioD0EWWeeklyMONTUEWED
JeffersonR2JGWeeklyMONTUEWED
WestonD022WeeklyMONTUEWED
WestonD0EMWeeklyMONTUEWED
WaukeganD0CGWeeklyMONTUEWED
AllentownD07AWeeklyTUEWEDTHU
BaltimoreD0HDWeeklyTUEWEDTHU
BaltimoreD0V1WeeklyTUEWEDTHU
5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

Hi @CaseyW 

 

Here is a workflow for the task. It gives date of next week date.

 

Output:

atcodedog05_0-1603387007255.png

Workflow:

atcodedog05_1-1603387022891.png

Hope this helps 🙂


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

 

CaseyW
5 - Atom

Dates don't match correctly in the solution, should match to the dates below but they don't.

 

Fri-     10/24

Mon - 10/26

Tue -  10/27

Wed - 10/28

Thu -  10/29

 

 

 

CaseyW_0-1603388895416.png

 

atcodedog05
22 - Nova
22 - Nova

Hi @CaseyW 

 

Apologies my bad. Fixed it

 

Output:

atcodedog05_0-1603390315774.png

 

Hope this helps please check and let me know.

 

CaseyW
5 - Atom

Perfect thank you!

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @CaseyW 

 

Cheers and Happy Analyzing 😀

Labels