topic How to duplicate records in QlikView https://community.qlik.com/t5/QlikView/How-to-duplicate-records/m-p/98720#M756894 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Good day all,</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I have a question. I have a table of unique CaseNo, the Client is providing Year column data separated by a backslash. I am trying to replicate the rows only where the year field is separated by "/ ". I have a requirement to provide a Count of all previous nsi by Year.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I have provided a sample table</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Thank you in advance.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Regards</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Mpfariseni</P><P></P><P></P><TABLE border="1" class="jiveBorder" jive-data-cell="{&quot;color&quot;:&quot;#000000&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P><STRONG>CaseNO</STRONG></P></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Previous NSI</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Previous_NSI#</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>YEAR</STRONG></TH></TR><TR><TD style="padding: 2px;">DD001</TD><TD style="padding: 2px;">YES</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">2016/2017</TD></TR><TR><TD style="padding: 2px;">DD002</TD><TD style="padding: 2px;">YES</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">2017/2018</TD></TR><TR><TD style="padding: 2px;">DD003</TD><TD style="padding: 2px;">YES</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">2009/2011</TD></TR><TR><TD style="padding: 2px;">DD004</TD><TD style="padding: 2px;">YES</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">2017</TD></TR><TR><TD style="padding: 2px;">DD005</TD><TD style="padding: 2px;">YES</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">2018</TD></TR><TR><TD style="padding: 2px;">DD006</TD><TD style="padding: 2px;">YES</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">2016</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT mpfariseni86 2020-11-25T16:16:04Z How to duplicate records https://community.qlik.com/t5/QlikView/How-to-duplicate-records/m-p/98720#M756894 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Good day all,</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I have a question. I have a table of unique CaseNo, the Client is providing Year column data separated by a backslash. I am trying to replicate the rows only where the year field is separated by "/ ". I have a requirement to provide a Count of all previous nsi by Year.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I have provided a sample table</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Thank you in advance.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Regards</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Mpfariseni</P><P></P><P></P><TABLE border="1" class="jiveBorder" jive-data-cell="{&quot;color&quot;:&quot;#000000&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P><STRONG>CaseNO</STRONG></P></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Previous NSI</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Previous_NSI#</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>YEAR</STRONG></TH></TR><TR><TD style="padding: 2px;">DD001</TD><TD style="padding: 2px;">YES</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">2016/2017</TD></TR><TR><TD style="padding: 2px;">DD002</TD><TD style="padding: 2px;">YES</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">2017/2018</TD></TR><TR><TD style="padding: 2px;">DD003</TD><TD style="padding: 2px;">YES</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">2009/2011</TD></TR><TR><TD style="padding: 2px;">DD004</TD><TD style="padding: 2px;">YES</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">2017</TD></TR><TR><TD style="padding: 2px;">DD005</TD><TD style="padding: 2px;">YES</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">2018</TD></TR><TR><TD style="padding: 2px;">DD006</TD><TD style="padding: 2px;">YES</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">2016</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-duplicate-records/m-p/98720#M756894 mpfariseni86 2020-11-25T16:16:04Z Re: How to duplicate records https://community.qlik.com/t5/QlikView/How-to-duplicate-records/m-p/98721#M756895 <HTML><HEAD></HEAD><BODY><P>Try this in your load script like </P><P></P><P>LOAD *, </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SUBFIELD(YEAR, '/') AS Year</P><P>From Yourtablename;</P></BODY></HTML> Thu, 06 Sep 2018 17:56:57 GMT https://community.qlik.com/t5/QlikView/How-to-duplicate-records/m-p/98721#M756895 vishsaggi 2018-09-06T17:56:57Z