topic Truncating and keeping data in different rows for a single ID in QlikView https://community.qlik.com/t5/QlikView/Truncating-and-keeping-data-in-different-rows-for-a-single-ID/m-p/1191526#M627975 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a data set like bellow mentioned -</P><TABLE border="1" class="jiveBorder" height="124" style="border: 1px solid rgb(0, 0, 0); width: 346px; height: 126px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">ID</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">No</TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">AA751485:AA750402:AA750402:AA2503271:AA751716</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">MBJ-AA3EM1</TD></TR></TBODY></TABLE><P></P><P>And I want the Output as below-</P><P></P><TABLE border="1" class="jiveBorder" height="174" style="border: 1px solid #000000; width: 180px; height: 167px;" width="178"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>No</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">AA751485</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">AA751485</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">AA750402</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">AA2503271</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">AA751716</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">MBJ-AA3EM1</SPAN></TD></TR></TBODY></TABLE><P></P><P>Can you please help me in getting this sorted.</P><P></P><P>Regards,</P><P>Rakesh Paul</P></BODY></HTML> Tue, 25 Oct 2016 09:53:42 GMT rakeshpaul 2016-10-25T09:53:42Z Truncating and keeping data in different rows for a single ID https://community.qlik.com/t5/QlikView/Truncating-and-keeping-data-in-different-rows-for-a-single-ID/m-p/1191526#M627975 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a data set like bellow mentioned -</P><TABLE border="1" class="jiveBorder" height="124" style="border: 1px solid rgb(0, 0, 0); width: 346px; height: 126px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">ID</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">No</TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">AA751485:AA750402:AA750402:AA2503271:AA751716</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">MBJ-AA3EM1</TD></TR></TBODY></TABLE><P></P><P>And I want the Output as below-</P><P></P><TABLE border="1" class="jiveBorder" height="174" style="border: 1px solid #000000; width: 180px; height: 167px;" width="178"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>No</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">AA751485</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">AA751485</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">AA750402</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">AA2503271</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">AA751716</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">MBJ-AA3EM1</SPAN></TD></TR></TBODY></TABLE><P></P><P>Can you please help me in getting this sorted.</P><P></P><P>Regards,</P><P>Rakesh Paul</P></BODY></HTML> Tue, 25 Oct 2016 09:53:42 GMT https://community.qlik.com/t5/QlikView/Truncating-and-keeping-data-in-different-rows-for-a-single-ID/m-p/1191526#M627975 rakeshpaul 2016-10-25T09:53:42Z Re: Truncating and keeping data in different rows for a single ID https://community.qlik.com/t5/QlikView/Truncating-and-keeping-data-in-different-rows-for-a-single-ID/m-p/1191527#M627976 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>Table:</STRONG></P><P><STRONG>LOAD ID, </STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; SubField(No, ':') as No</STRONG></P><P><STRONG>FROM</STRONG></P><P><STRONG><SPAN>[</SPAN><A class="jive-link-thread-small" data-containerid="2061" data-containertype="14" data-objectid="237520" data-objecttype="1" href="https://community.qlik.com/thread/237520">https://community.qlik.com/thread/237520</A><SPAN>]</SPAN></STRONG></P><P><STRONG>(html, codepage is 1252, embedded labels, table is @1);</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/141868_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 25 Oct 2016 15:55:32 GMT https://community.qlik.com/t5/QlikView/Truncating-and-keeping-data-in-different-rows-for-a-single-ID/m-p/1191527#M627976 sunny_talwar 2016-10-25T15:55:32Z