https://community.qlik.com/t5/QlikView/How-to-split-one-Row-into-multiple-rows/m-p/1756938#M719797 <P>Hi sir.</P><P>It's not working.</P><P>&nbsp;</P> Thu, 29 Oct 2020 07:22:25 GMT Vinod 2020-10-29T07:22:25Z https://community.qlik.com/t5/QlikView/How-to-split-one-Row-into-multiple-rows/m-p/1756915#M719795 <P>Hi All.</P><P>How to split data into multiple rows based on the input data.</P><P>Can anyone help me on this.</P><P>I have attached sample data set for your reference(Refer Sheet1 for Input data and Sheet2 for Excepted ouput).&nbsp;</P><P>Regards,</P><P>Vinod</P> Fri, 15 Nov 2024 23:43:24 GMT https://community.qlik.com/t5/QlikView/How-to-split-one-Row-into-multiple-rows/m-p/1756915#M719795 Vinod 2024-11-15T23:43:24Z https://community.qlik.com/t5/QlikView/How-to-split-one-Row-into-multiple-rows/m-p/1756919#M719796 <P>You can use Subfield () for this.</P><P>Load <STRONG>SubField([Numbers], ' ')&nbsp; as Number</STRONG></P><P>From Excel</P> Thu, 29 Oct 2020 06:11:34 GMT https://community.qlik.com/t5/QlikView/How-to-split-one-Row-into-multiple-rows/m-p/1756919#M719796 Vegar 2020-10-29T06:11:34Z https://community.qlik.com/t5/QlikView/How-to-split-one-Row-into-multiple-rows/m-p/1756938#M719797 <P>Hi sir.</P><P>It's not working.</P><P>&nbsp;</P> Thu, 29 Oct 2020 07:22:25 GMT https://community.qlik.com/t5/QlikView/How-to-split-one-Row-into-multiple-rows/m-p/1756938#M719797 Vinod 2020-10-29T07:22:25Z