topic separate table field in QlikView https://community.qlik.com/t5/QlikView/separate-table-field/m-p/1300838#M405446 <HTML><HEAD></HEAD><BODY><P>hi</P><P>i have a table like below:</P><TABLE border="1" class="jiveBorder" height="74" style="border: 1px solid rgb(0, 0, 0); width: 184px; height: 63px;"><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>A</STRONG></TH></TR><TR><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">1,2,3,4</TD></TR><TR><TD style="padding: 2px;">200</TD><TD style="padding: 2px;">2,5,6</TD></TR></TBODY></TABLE><P>i want to convert it to a table like below:</P><TABLE border="1" class="jiveBorder" height="149" style="border: 1px solid rgb(0, 0, 0); width: 182px; height: 140px;"><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>A</STRONG></TH></TR><TR><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">4</TD></TR><TR><TD style="padding: 2px;">200</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">200</TD><TD style="padding: 2px;">5</TD></TR><TR><TD style="padding: 2px;">200</TD><TD style="padding: 2px;">6</TD></TR></TBODY></TABLE><P>what can i do?</P></BODY></HTML> Sun, 23 Apr 2017 05:49:01 GMT omid5ive 2017-04-23T05:49:01Z separate table field https://community.qlik.com/t5/QlikView/separate-table-field/m-p/1300838#M405446 <HTML><HEAD></HEAD><BODY><P>hi</P><P>i have a table like below:</P><TABLE border="1" class="jiveBorder" height="74" style="border: 1px solid rgb(0, 0, 0); width: 184px; height: 63px;"><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>A</STRONG></TH></TR><TR><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">1,2,3,4</TD></TR><TR><TD style="padding: 2px;">200</TD><TD style="padding: 2px;">2,5,6</TD></TR></TBODY></TABLE><P>i want to convert it to a table like below:</P><TABLE border="1" class="jiveBorder" height="149" style="border: 1px solid rgb(0, 0, 0); width: 182px; height: 140px;"><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>A</STRONG></TH></TR><TR><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">4</TD></TR><TR><TD style="padding: 2px;">200</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">200</TD><TD style="padding: 2px;">5</TD></TR><TR><TD style="padding: 2px;">200</TD><TD style="padding: 2px;">6</TD></TR></TBODY></TABLE><P>what can i do?</P></BODY></HTML> Sun, 23 Apr 2017 05:49:01 GMT https://community.qlik.com/t5/QlikView/separate-table-field/m-p/1300838#M405446 omid5ive 2017-04-23T05:49:01Z Re: separate table field https://community.qlik.com/t5/QlikView/separate-table-field/m-p/1300839#M405447 <HTML><HEAD></HEAD><BODY><P>Where you are expecting? If script may be this?</P><P></P><P><STRONG>LOAD ID, SubField(A,',') as A;</STRONG></P><P><STRONG>LOAD ID, </STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A</STRONG></P><P><STRONG>FROM</STRONG></P><P><STRONG>&lt;Source&gt;</STRONG></P></BODY></HTML> Sun, 23 Apr 2017 06:04:23 GMT https://community.qlik.com/t5/QlikView/separate-table-field/m-p/1300839#M405447 Anil_Babu_Samineni 2017-04-23T06:04:23Z