topic Re: transpose data from columns to row & inserting date in between 2 dates in QlikView https://community.qlik.com/t5/QlikView/transpose-data-from-columns-to-row-inserting-date-in-between-2/m-p/48265#M8032 <HTML><HEAD></HEAD><BODY><P>Check my response here</P><P><A href="https://community.qlik.com/message/1464751">Re: Start and End Date Conversion</A></P></BODY></HTML> Wed, 04 Apr 2018 15:58:45 GMT sunny_talwar 2018-04-04T15:58:45Z transpose data from columns to row & inserting date in between 2 dates https://community.qlik.com/t5/QlikView/transpose-data-from-columns-to-row-inserting-date-in-between-2/m-p/48264#M8031 <HTML><HEAD></HEAD><BODY><P>Current format:&nbsp;&nbsp; </P><P>Table1</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 255px;"><TBODY><TR><TD align="left" height="19" width="94">VacStartDate</TD><TD align="left" width="89">VacEndDate</TD><TD align="left" width="72">Emp</TD></TR><TR><TD align="right" class="xl63" height="19">28/01/2018</TD><TD align="right" class="xl63">02/02/2018</TD><TD align="right">140115</TD></TR><TR><TD align="right" class="xl63" height="19">23/01/2018</TD><TD align="right" class="xl63">24/01/2018</TD><TD align="right"><P>140009</P><P></P></TD></TR></TBODY></TABLE><P></P><P></P><P>Please if you can help me convert&nbsp; when loading:</P><P>I need something like this</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 183px;"><TBODY><TR><TD align="left" height="19" width="94">Date</TD><TD align="left" width="89">Emp</TD></TR><TR><TD align="right" class="xl65" height="19">28/01/2018</TD><TD align="right">140115</TD></TR><TR><TD align="right" class="xl65" height="19">29/01/2019</TD><TD align="right">140115</TD></TR><TR><TD align="right" class="xl65" height="19">30/01/2020</TD><TD align="right">140115</TD></TR><TR><TD align="right" class="xl65" height="19">30/01/2021</TD><TD align="right">140115</TD></TR><TR><TD align="right" class="xl65" height="19">31/01/2022</TD><TD align="right">140115</TD></TR><TR><TD align="right" class="xl65" height="19">01/02/2023</TD><TD align="right">140115</TD></TR><TR><TD align="right" class="xl65" height="19">02/02/2024</TD><TD align="right">140115</TD></TR><TR><TD align="right" class="xl65" height="19">23/01/2018</TD><TD align="right">140009</TD></TR><TR><TD align="right" class="xl65" height="19">24/01/2018</TD><TD align="right">140009</TD></TR></TBODY></TABLE><P></P><P>Thanks a lot,</P><P>Mike</P></BODY></HTML> Tue, 03 Apr 2018 15:33:21 GMT https://community.qlik.com/t5/QlikView/transpose-data-from-columns-to-row-inserting-date-in-between-2/m-p/48264#M8031 michaelmedaflor 2018-04-03T15:33:21Z Re: transpose data from columns to row & inserting date in between 2 dates https://community.qlik.com/t5/QlikView/transpose-data-from-columns-to-row-inserting-date-in-between-2/m-p/48265#M8032 <HTML><HEAD></HEAD><BODY><P>Check my response here</P><P><A href="https://community.qlik.com/message/1464751">Re: Start and End Date Conversion</A></P></BODY></HTML> Wed, 04 Apr 2018 15:58:45 GMT https://community.qlik.com/t5/QlikView/transpose-data-from-columns-to-row-inserting-date-in-between-2/m-p/48265#M8032 sunny_talwar 2018-04-04T15:58:45Z