Start and End Date Conversion

[michaelmedaflor]

Please if you can help me convert my table from column to rows using load script

Here is my table;

VacStartDate	VacEndDate	Emp
28/01/2018	02/02/2018	140115
23/01/2018	24/01/2018	140009

Please if you can help me convert into this;  

Date	Emp
28/01/2018	140115
29/01/2019	140115
30/01/2020	140115
30/01/2021	140115
31/01/2022	140115
01/02/2023	140115
02/02/2024	140115
23/01/2018	140009
24/01/2018	140009

Thank you,

Mike

[sunny_talwar]

Try this

Table:

LOAD Date(VacStartDate + IterNo() - 1) as Date,

Emp

While VacStartDate + IterNo() - 1 <= VacEndDate;

LOAD * INLINE [

    VacStartDate, VacEndDate, Emp

    28/01/2018, 02/02/2018, 140115

    23/01/2018, 24/01/2018, 140009

];