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'))
