Transform Data

[zwyne]

Hi Experts,

PFA,

I need some assistance in transforming the attached data. I have a fields called TIMESHEET_DATE and HOURS, so what I want to do is to create the Start Date and End Date based on the TIMESHEET_DATE and then calculate the timespent on the Task_Name for each Resource Name

[girish2195]

How to create start date and end date from single field ?

Do we need to add hours field to Timesheet_Date ?

[zwyne]

Yes please.

[zwyne]

Yes please.

[zwyne]

Hello again, the expected output is as below. The headings 1 - 15, 16 - 31 and e.t.c are two weeks per month and the data for example 84.59 is number of hours for that period.

[lorenzoconforti · Accepted solution]

Something like this?

[zwyne]

Thank you for your assistance. So for the second part do I have to create the Calendar for the Buckets?

[lorenzoconforti]

I forgot the second chart you had in your message

See attached updated

[lorenzoconforti]

See my other post