Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Alteryx Designer Desktop Discussions

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

Data Preparation Date and by Date Range

enocperez
6 - Meteoroid

I have Data coming from Excel for Pay Roll.  

 alteryx 2.jpg

  How I need to take the data to the next step.  Week 1 Reg. Hour  and Over Time. Week 2  Reg. Hours worked and Over time.  But don't know how to do it.  I have been at it for some time know.

 

 

alteryx 1.jpg

 

 

 

 

 

12 REPLIES 12
enocperez
6 - Meteoroid

So here is the version.

I have it working now.   About the formula to adjust the week number from Sunday to Monday.  I just add that to the expression or add another Formula with that expression.  Sorry again new to Alteryx.   


alteryx Lic.jpg

 

 

 

JordanB
Alteryx
Alteryx

Hi @enocperez

 

Attached in the workflow which has the additional of the multi-row formula.

 

Best,

 

Jordan

enocperez
6 - Meteoroid

Thank you JordanB.  You help me out a lot.  

Labels