I have Data coming from Excel for Pay Roll.
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.
Hi @enocperez
Attached in the workflow which has the additional of the multi-row formula.
Best,
Jordan
I am not entirely sure how to arrive at the fields you have below with your sample data. Is it possible to send some sample data, as well as how to calculate Reg. HR & OT Hr. As well as what quantifies at week 1, week 2 etc.
I have attached a workflow which may demonstrate what you need, but additional information would be appreciated.
Jordan Barker
Solutions Consultant
Here is the HR Customer Sample Data and below is the flow that I have so far.
From this data how are you looking to aggregate for the different weeks? Based on the date field?
I don't know how to. I was thing using another excel sheet to do that but don't know how to get it to work.
Attached is a workflow which uses the week number formula within Alteryx.
Formula: tonumber(DateTimeFormat([Date],'%U'))
Hi JordanB,
How do I change the Beginning of the week to be Monday and not Sunday?
It seems we don't have the same version of Alteryx. What version are you on? You can find this by going to help>>About in the Designer
I can amend the workflow so you cana open it. I have added a multi-row formula to adjust the weeknumber from sunday to monday.
IF [WeekDay]='Sunday' THEN [Row-1:Week Number] ELSE [Week Number] ENDIF
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.
