Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table of EmpID, Date, SwipeIn/Out Time, Type as below image.
Now i would like to calculate each employee total spent time by calculating the first in and and last out for each day of for each employee.
To get First In i did used tAggregaterow but here i cant make a condition that the TIME should be Type IN
Then, While at the time of data loading itself, i filtered using Mysql query and created a pipeline for In's and another pipeline for Outs.
That means, i did used two taggregaterow's to calculate the first in and last out.
How can i make it in single tAggregaterow to Calculate FirstIn(Min of Time where Type = IN) and LastOut(max of Time where Type = Out).
is it possible with Talend.
Output That i am expecting is:-
Can anyone please guide me
Regards,
Mohan V.