Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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 Alumni (Retired)

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
Top Solution Authors