topic Unconcatenate cell value in QlikView https://community.qlik.com/t5/QlikView/Unconcatenate-cell-value/m-p/724561#M670976 <HTML><HEAD></HEAD><BODY><P>Hi everyone!</P><P></P><P>i have&nbsp; field like this</P><TABLE border="0" cellpadding="0" cellspacing="0" height="24" style="height: 21px; width: 692px;" width="690"><TBODY><TR><TD height="17" width="64">&lt;data&gt;&lt;field id="1084"/&gt;&lt;field id="1085"&gt;109&lt;/field&gt;&lt;field id="1087"&gt;0&lt;/field&gt;&lt;field id="1088"&gt;1&lt;/field&gt;&lt;/data&gt;</TD></TR></TBODY></TABLE><P></P><P>how extract it to </P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><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>Vaule</STRONG></TH></TR><TR><TD style="padding: 2px;">1184</TD><TD style="padding: 2px;">null</TD></TR><TR><TD style="padding: 2px;">1185</TD><TD style="padding: 2px;">1109</TD></TR><TR><TD style="padding: 2px;">1187</TD><TD style="padding: 2px;">0</TD></TR><TR><TD style="padding: 2px;">1188</TD><TD style="padding: 2px;">1</TD></TR></TBODY></TABLE><P>?</P></BODY></HTML> Wed, 17 Sep 2014 21:32:38 GMT omnomnom 2014-09-17T21:32:38Z Unconcatenate cell value https://community.qlik.com/t5/QlikView/Unconcatenate-cell-value/m-p/724561#M670976 <HTML><HEAD></HEAD><BODY><P>Hi everyone!</P><P></P><P>i have&nbsp; field like this</P><TABLE border="0" cellpadding="0" cellspacing="0" height="24" style="height: 21px; width: 692px;" width="690"><TBODY><TR><TD height="17" width="64">&lt;data&gt;&lt;field id="1084"/&gt;&lt;field id="1085"&gt;109&lt;/field&gt;&lt;field id="1087"&gt;0&lt;/field&gt;&lt;field id="1088"&gt;1&lt;/field&gt;&lt;/data&gt;</TD></TR></TBODY></TABLE><P></P><P>how extract it to </P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><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>Vaule</STRONG></TH></TR><TR><TD style="padding: 2px;">1184</TD><TD style="padding: 2px;">null</TD></TR><TR><TD style="padding: 2px;">1185</TD><TD style="padding: 2px;">1109</TD></TR><TR><TD style="padding: 2px;">1187</TD><TD style="padding: 2px;">0</TD></TR><TR><TD style="padding: 2px;">1188</TD><TD style="padding: 2px;">1</TD></TR></TBODY></TABLE><P>?</P></BODY></HTML> Wed, 17 Sep 2014 21:32:38 GMT https://community.qlik.com/t5/QlikView/Unconcatenate-cell-value/m-p/724561#M670976 omnomnom 2014-09-17T21:32:38Z Re: Unconcatenate cell value https://community.qlik.com/t5/QlikView/Unconcatenate-cell-value/m-p/724562#M670977 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>one possible solution:</P><P></P><P><IMG alt="QlikCommunity_Thread_133828_Pic1.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/67046_QlikCommunity_Thread_133828_Pic1.JPG.jpg" /></P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="_jivemacro_uid_14109941449222810 jive_text_macro jive_macro_code" jivemacro_uid="_14109941449222810"> <P>tabInput:</P> <P>LOAD *,</P> <P>&nbsp;&nbsp;&nbsp;&nbsp; RecNo() as RecNo</P> <P>INLINE [</P> <P>&nbsp;&nbsp;&nbsp; field</P> <P>&nbsp;&nbsp;&nbsp; '&lt;data&gt;&lt;field id="1084"/&gt;&lt;field id="1085"&gt;109&lt;/field&gt;&lt;field id="1087"&gt;0&lt;/field&gt;&lt;field id="1088"&gt;1&lt;/field&gt;&lt;/data&gt;'</P> <P>];</P> <P></P> <P>tabOutput:</P> <P>LOAD RecNo,</P> <P>&nbsp;&nbsp;&nbsp;&nbsp; SubField(SubField, '"', 1) as ID,</P> <P>&nbsp;&nbsp;&nbsp;&nbsp; TextBetween(SubField, '&gt;', '&lt;', 1) as Value</P> <P>Where SubField &lt;&gt; '&lt;data&gt;';</P> <P>LOAD RecNo,</P> <P>&nbsp;&nbsp;&nbsp;&nbsp; SubField(field, '&lt;field id="') as SubField</P> <P>Resident tabInput;</P> </PRE><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Wed, 17 Sep 2014 22:48:40 GMT https://community.qlik.com/t5/QlikView/Unconcatenate-cell-value/m-p/724562#M670977 MarcoWedel 2014-09-17T22:48:40Z