Scenario needs to be solved

devesh_ssingh · Post by **devesh_ssingh** » Fri Nov 25, 2011 4:53 am

Hi All,

I have come accross one scenario, kindly help me to solve it.

i/p

Emp_id IN_Time Out_time
1234 09:30 10:30
1234 11:00 14:00
1234 15:00 17:00
1234 17:30 18:30

O/p

Emp_id IN_Time Out_Time Productive_time Idle_time
1234 09:30 18:30 7hrs 2hrs

regards,
D

chulett · Post by **chulett** » Fri Nov 25, 2011 7:52 am

Please try to come up with more descriptive subject lines, pretty much everything here is a "scenario that needs to be solved". Also, rather than force people to puzzle out the relationship between the input and the ouput examples, it is always best to spell out your requirements in words. Explain to us rather than make us guess or work out how to get there from here.

ray.wurlod · Post by **ray.wurlod** » Fri Nov 25, 2011 1:43 pm

How do you calculate productive time? How do you calculate idle time? Could this be different for different employee types? What other business rules have you neglected to mention? Does the organisation have a PHB?

paultechm · Post by **paultechm** » Fri Nov 25, 2011 4:39 pm

Create a column called Productive_time in transformer with value as Out_time-IN_Time

Emp_id IN_Time Out_time Productive_time
1234 09:30 10:30 1
1234 11:00 14:00 3
1234 15:00 17:00 2
1234 17:30 18:30 1

pass this to an aggregator stage group with Emp_id and calculate min(in_time),max(out_time),sum(Productive_time) and
Idle_time can be calculated as (max(out_time)-min(in_time))-sum(Productive_time)

chulett · Post by **chulett** » Fri Nov 25, 2011 6:24 pm

Paul, thanks for helping out but just want to point out that you seem to be missing the point of our responses. Ray or I could have put together a very similar reply based on our understanding of what was posted.

However, in the spirit of "teach a man to fish" we prefer to take a moment to help educate posters on how to ask for help, to include enough information so that their problem can be understood and hopefully solved without ambiguity. Simply posting a sample of the Input and desired Output with no explanation of the requirements or what (if anything at all) that they have tried is one of my pet peeves. I don't really believe in 'Silver Platter' answers and would nuch rather help someone work it out by themselves as much as possible. And a big part of that is properly explaining the scenario that needs to be solved and what they've tried up to this point, rather than simply presenting it as if it were some puzzle for us.

My two cents.

paultechm · Post by **paultechm** » Sat Nov 26, 2011 3:31 am

Sorry , I haven't noticed your comments , I know that the post doesn't have much explanation of the requirements .

chulett · Post by **chulett** » Sat Nov 26, 2011 7:17 am

Much? Any. Hence the issue.