topic How to load different ranges in single column in QlikView https://community.qlik.com/t5/QlikView/How-to-load-different-ranges-in-single-column/m-p/367302#M136563 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P></P><P>I've data, maintained in the following format</P><P></P><P>610,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0900101101,&nbsp;&nbsp;&nbsp;&nbsp; 0900101119</P><P>611,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0900107202,&nbsp;&nbsp;&nbsp;&nbsp; 0900107203</P><P>611,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0900101120,&nbsp;&nbsp;&nbsp;&nbsp; 0900101121</P><P></P><P>The first column in above data denotes GROUP, while the second column contains START value and last column contains END value of a range. How can I load this data in GROUP, VALUE format as follows:</P><P></P><P></P><P>610,0900101101</P><P>610,0900101102</P><P>610.0900101103</P><P>.. so on</P><P>611, 0900107202</P><P>611, 0900107203</P><P>.. so on</P><P></P><P></P><P>Thanks</P></BODY></HTML> Thu, 24 May 2012 10:15:26 GMT 2012-05-24T10:15:26Z How to load different ranges in single column https://community.qlik.com/t5/QlikView/How-to-load-different-ranges-in-single-column/m-p/367302#M136563 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P></P><P>I've data, maintained in the following format</P><P></P><P>610,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0900101101,&nbsp;&nbsp;&nbsp;&nbsp; 0900101119</P><P>611,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0900107202,&nbsp;&nbsp;&nbsp;&nbsp; 0900107203</P><P>611,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0900101120,&nbsp;&nbsp;&nbsp;&nbsp; 0900101121</P><P></P><P>The first column in above data denotes GROUP, while the second column contains START value and last column contains END value of a range. How can I load this data in GROUP, VALUE format as follows:</P><P></P><P></P><P>610,0900101101</P><P>610,0900101102</P><P>610.0900101103</P><P>.. so on</P><P>611, 0900107202</P><P>611, 0900107203</P><P>.. so on</P><P></P><P></P><P>Thanks</P></BODY></HTML> Thu, 24 May 2012 10:15:26 GMT https://community.qlik.com/t5/QlikView/How-to-load-different-ranges-in-single-column/m-p/367302#M136563 2012-05-24T10:15:26Z Re: How to load different ranges in single column https://community.qlik.com/t5/QlikView/How-to-load-different-ranges-in-single-column/m-p/367303#M136564 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check <A _jive_internal="true" href="https://community.qlik.com/thread/53577">this thread</A> I posted in recently. It works and has very different ways to implement it, including sample applications.</P><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Thu, 24 May 2012 10:24:11 GMT https://community.qlik.com/t5/QlikView/How-to-load-different-ranges-in-single-column/m-p/367303#M136564 Miguel_Angel_Baeyens 2012-05-24T10:24:11Z