Data generation

Question

Hello Team,

From the below input:

InputEmployeeNameStart Date End DateCodeDurationDates1Ravi3/10/20253/11/2025Vacation163/10/20251Ravi3/10/20253/11/2025Vacation163/11/20252Shiv5/12/20255/14/2025Sick245/12/20252Shiv5/12/20255/14/2025Sick245/14/20252Shiv5/12/20255/14/2025Sick245/14/20253Raj6/11/20256/11/2025Floating86/11/2025

and trying to generate the following output:

OutputEmployeeNameStart Date End DateCodeDurationDatesActual Duration 1Ravi3/10/20253/11/2025Vacation163/10/202581Ravi3/10/20253/11/2025Vacation163/11/202582Shiv5/12/20255/14/2025Sick245/12/202582Shiv5/12/20255/14/2025Sick245/14/202582Shiv5/12/20255/14/2025Sick245/14/202583Raj6/11/20256/11/2025Floating86/11/20258

binu_acs · Accepted Answer

@Hiteshp one way of doing this with the help of summarise tool and join tool

CoG · Accepted Answer

Since you are Generating Rows and already have the Start Date and End Date in the data, you can utilize that without needing to Summarize: