topic Re: Renumbering data in QlikView https://community.qlik.com/t5/QlikView/Renumbering-data/m-p/1555677#M597820 <P>Thank You - it work like a charm - great!</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 12 Mar 2019 21:35:40 GMT chrisk44 2019-03-12T21:35:40Z Renumbering data https://community.qlik.com/t5/QlikView/Renumbering-data/m-p/1555444#M597816 <DIV class="topic-subject-wrapper"><DIV class="lia-message-subject lia-component-message-view-widget-subject"><DIV class="MessageSubject"><SPAN>Hello All.</SPAN></DIV></DIV></DIV><DIV class="lia-message-body lia-component-message-view-widget-body lia-component-body-signature-highlight-escalation lia-component-message-view-widget-body-signature-highlight-escalation"><DIV class="lia-message-body-content"><P>I'm new to QV -and&nbsp;</P><P>I have a problem with renumbering rows in the database... Namely:<BR />The source table looks like this:</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>ID</TD><TD>DATE</TD></TR><TR><TD>1111</TD><TD>1999-02-15</TD></TR><TR><TD>1111</TD><TD>2008-09-24</TD></TR><TR><TD>2222</TD><TD>2002-06-20</TD></TR><TR><TD>2222</TD><TD>2002-06-20</TD></TR><TR><TD>3333</TD><TD>1996-01-02</TD></TR><TR><TD>3333</TD><TD>2008-07-16</TD></TR><TR><TD>3333</TD><TD>2018-11-30</TD></TR><TR><TD>4444</TD><TD>1998-09-01</TD></TR></TBODY></TABLE><P>Ultimately, for each date change, you should generate a new ID number - new column based old one with ID and one in succession of 1, 2, 3 etc...:</P><TABLE><TBODY><TR><TD>ID</TD><TD>DATE</TD><TD>RENUMBERED_ID</TD></TR><TR><TD>1111</TD><TD>1999-02-15</TD><TD>11111</TD></TR><TR><TD>1111</TD><TD>2008-09-24</TD><TD>11112</TD></TR><TR><TD>2222</TD><TD>2002-06-20</TD><TD>22221</TD></TR><TR><TD>2222</TD><TD>2002-06-20</TD><TD>22221</TD></TR><TR><TD>3333</TD><TD>1996-01-02</TD><TD>33331</TD></TR><TR><TD>3333</TD><TD>2008-07-16</TD><TD>33332</TD></TR><TR><TD>3333</TD><TD>2018-11-30</TD><TD>33333</TD></TR><TR><TD>4444</TD><TD>1998-09-01</TD><TD>44441</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks in advance.</P></DIV></DIV> Tue, 12 Mar 2019 14:23:09 GMT https://community.qlik.com/t5/QlikView/Renumbering-data/m-p/1555444#M597816 chrisk44 2019-03-12T14:23:09Z Re: Renumbering data https://community.qlik.com/t5/QlikView/Renumbering-data/m-p/1555553#M597818 <P>ID &amp; AutoNumber(DATE, ID) as&nbsp;<SPAN>RENUMBERED_ID</SPAN></P><P>-Rob</P> Tue, 12 Mar 2019 16:35:11 GMT https://community.qlik.com/t5/QlikView/Renumbering-data/m-p/1555553#M597818 rwunderlich 2019-03-12T16:35:11Z Re: Renumbering data https://community.qlik.com/t5/QlikView/Renumbering-data/m-p/1555677#M597820 <P>Thank You - it work like a charm - great!</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 12 Mar 2019 21:35:40 GMT https://community.qlik.com/t5/QlikView/Renumbering-data/m-p/1555677#M597820 chrisk44 2019-03-12T21:35:40Z