Hi Community, Hope everyone is doing well. I'm struggling to split rows based on condition. Following is the format of data;Employee CodeLeave Start DateLeave End DateHoursPeriod End Datestart weekDays diffNet work days9385/10/202023/10/20207523/10/202041181588418/12/20201/01/202137.51/01/20215114112055/04/202119/04/202167/05/20211514114985/12/202018/12/20207518/12/20204913104987/11/202020/11/20207520/11/2020451310 I want to put a condition on days diff as follows; Daysdiff > 14 = 3 rowsDaysdiff > 7 = 2 rowsDaydiff < 7 = 1 row with the split, I need two columns such as "Start of week" and "Apportioned hours" Following is what I expect to see as the result; Employee CodeLeave Start DateLeave End DateHoursPeriod End Datestart weekDays diffNet work daysApportioned hoursStart of week9385/10/202023/10/20207523/10/2020411815255/10/20209385/10/202023/10/20207523/10/20204118152512/10/20209385/10/202023/10/20207523/10/20204118152519/10/2020 Any help with this is highly appreciated. Thank you in advance Best regards,Ashan

Anonymous

Not applicable

5 years ago

Solved

Split rows based on condition

Hi Community,

Hope everyone is doing well.

I'm struggling to split rows based on condition. Following is the format of data;

I want to put a condition on days diff as follows;

Daysdiff > 14 = 3 rows

Daysdiff > 7 = 2 rows

Daydiff < 7 = 1 row

with the split, I need two columns such as "Start of week" and "Apportioned hours"

Following is what I expect to see as the result;