Can someone please help me with below requirement Logic and function to be used.
I need to filter by JOB and Task with start and end time for JO and event respectively.
I need to get table similar so that i can filter in the front end by Job and Task
Have you tried calculating start and end time during the data load? Assuming only one JOB runs at a time...
I would say do group by Job and take MinDate(with timestamp ) as Start date and MaxDate(with timestamp) as EndDate, and take start time from start date and End time from EndDate
Thank you for the reply.
Grouped the job using Row num and Peek function , made a different table for end time and it worked got helped by Petter in the community.