topic Re: how to split the data into new record in QlikView https://community.qlik.com/t5/QlikView/how-to-split-the-data-into-new-record/m-p/1149201#M632594 <HTML><HEAD></HEAD><BODY><P>May be try this:</P><P></P><P><STRONG>PurgeChar(SubField(Source, '-'), Chr(34)) as Expected</STRONG></P></BODY></HTML> Wed, 08 Jun 2016 09:09:55 GMT sunny_talwar 2016-06-08T09:09:55Z how to split the data into new record https://community.qlik.com/t5/QlikView/how-to-split-the-data-into-new-record/m-p/1149200#M632593 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P></P><P>i have source table record like this</P><P></P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid rgb(0, 0, 0); width: 193px; height: 82px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Source Records</TH></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">"AA"-"AB"-"CC"-"DD"</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">"AM"-"AD"</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">"AH"-"AN"-"BL"</SPAN></TD></TR></TBODY></TABLE><P></P><P>I need to load the data below mentioned format.</P><P></P><TABLE border="1" class="jiveBorder" height="74" style="border: 1px solid rgb(0, 0, 0); width: 125px; height: 75px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Expected Result</TH></TR><TR><TD style="padding: 2px;">AA</TD></TR><TR><TD style="padding: 2px;"><P>AB</P></TD></TR><TR><TD style="padding: 2px;">CC</TD></TR><TR><TD style="padding: 2px;">DD</TD></TR><TR><TD style="padding: 2px;">AM</TD></TR><TR><TD style="padding: 2px;">AD</TD></TR><TR><TD style="padding: 2px;">AH</TD></TR><TR><TD style="padding: 2px;">AN</TD></TR><TR><TD style="padding: 2px;">BL</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 08 Jun 2016 09:06:16 GMT https://community.qlik.com/t5/QlikView/how-to-split-the-data-into-new-record/m-p/1149200#M632593 muniyandi 2016-06-08T09:06:16Z Re: how to split the data into new record https://community.qlik.com/t5/QlikView/how-to-split-the-data-into-new-record/m-p/1149201#M632594 <HTML><HEAD></HEAD><BODY><P>May be try this:</P><P></P><P><STRONG>PurgeChar(SubField(Source, '-'), Chr(34)) as Expected</STRONG></P></BODY></HTML> Wed, 08 Jun 2016 09:09:55 GMT https://community.qlik.com/t5/QlikView/how-to-split-the-data-into-new-record/m-p/1149201#M632594 sunny_talwar 2016-06-08T09:09:55Z Re: how to split the data into new record https://community.qlik.com/t5/QlikView/how-to-split-the-data-into-new-record/m-p/1149202#M632595 <HTML><HEAD></HEAD><BODY><P>For your sample:</P><P></P><P><STRONG>Table:</STRONG></P><P><STRONG>LOAD *,</STRONG></P><P><STRONG>&nbsp; PurgeChar(SubField([Source Records], '-'), Chr(34)) as Expected;</STRONG></P><P><STRONG>LOAD * INLINE [</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; Source Records</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; '"AA"-"AB"-"CC"-"DD"'</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; '"AM"-"AD"'</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; '"AH"-"AN"-"BL"'</STRONG></P><P><STRONG>];</STRONG></P><P></P><P><IMG __jive_id="127211" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/127211_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 08 Jun 2016 09:12:32 GMT https://community.qlik.com/t5/QlikView/how-to-split-the-data-into-new-record/m-p/1149202#M632595 sunny_talwar 2016-06-08T09:12:32Z Re: how to split the data into new record https://community.qlik.com/t5/QlikView/how-to-split-the-data-into-new-record/m-p/1149203#M632596 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny T</P><P>Some data have number also</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">"AH#<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">2</SPAN>"-"AN#6"-"BL#8"</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;"><BR /></SPAN></P></BODY></HTML> Wed, 08 Jun 2016 09:39:16 GMT https://community.qlik.com/t5/QlikView/how-to-split-the-data-into-new-record/m-p/1149203#M632596 muniyandi 2016-06-08T09:39:16Z Re: how to split the data into new record https://community.qlik.com/t5/QlikView/how-to-split-the-data-into-new-record/m-p/1149204#M632597 <HTML><HEAD></HEAD><BODY><P>Would this be the output you would want to see?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/127213_Capture.PNG" style="height: auto;" /></P><P></P><P>Still using the same script:</P><P></P><P><STRONG>Table:</STRONG></P><P><STRONG>LOAD *,</STRONG></P><P><STRONG> </STRONG> <STRONG>PurgeChar(SubField([Source Records], '-'), Chr(34)) as Expected;</STRONG></P><P><STRONG>LOAD * INLINE [</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; Source Records</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; '"AA"-"AB"-"CC"-"DD"'</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; '"AM"-"AD"'</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; '"AH"-"AN"-"BL"'</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;">'"AH#2"-"AN#6"-"BL#8"'</SPAN></STRONG></P><P><STRONG>];</STRONG></P></BODY></HTML> Wed, 08 Jun 2016 09:42:23 GMT https://community.qlik.com/t5/QlikView/how-to-split-the-data-into-new-record/m-p/1149204#M632597 sunny_talwar 2016-06-08T09:42:23Z Re: how to split the data into new record https://community.qlik.com/t5/QlikView/how-to-split-the-data-into-new-record/m-p/1149205#M632598 <HTML><HEAD></HEAD><BODY><P><STRONG><EM>try this</EM></STRONG></P><P></P><P><STRONG><EM>Subfield(keepchar(Field,'ABCDEFGHIJKLMNOPQRSTUVWXYZ-'),'-') as Result</EM></STRONG></P></BODY></HTML> Wed, 08 Jun 2016 09:44:56 GMT https://community.qlik.com/t5/QlikView/how-to-split-the-data-into-new-record/m-p/1149205#M632598 Kushal_Chawda 2016-06-08T09:44:56Z