Start and End Date Conversion

michaelmedaflor — Tue, 03 Apr 2018 15:45:40 GMT

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

Here is my table;

Please if you can help me convert into this;

Thank you,

Mike

Re: Start and End Date Conversion

sunny_talwar — Wed, 04 Apr 2018 15:58:17 GMT

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

];