topic Re: Create Duplicate rows in QlikView https://community.qlik.com/t5/QlikView/Create-Duplicate-rows/m-p/394087#M146948 <HTML><HEAD></HEAD><BODY><P>If doing this in load script, you can try this ...</P><P></P><P><STRONG>Data:</STRONG></P><P><STRONG>Load RowNo() as RowId, * while iterno() &lt;= Score;</STRONG></P><P><STRONG>load * inline [</STRONG></P><P><STRONG>User, Score</STRONG></P><P><STRONG>A,1</STRONG></P><P><STRONG>B,2</STRONG></P><P><STRONG>C,4</STRONG></P><P><STRONG>D,18</STRONG></P><P><STRONG>E,0];</STRONG></P><P></P><P>flipside</P></BODY></HTML> Fri, 30 Nov 2012 11:11:11 GMT flipside 2012-11-30T11:11:11Z Create Duplicate rows https://community.qlik.com/t5/QlikView/Create-Duplicate-rows/m-p/394086#M146947 <HTML><HEAD></HEAD><BODY><P>Good day all,</P><P></P><P>I have a question. I have a table of unique users with scores, these scores are 7, 3 and 1. I am trying to replicate the rows based on the score value. So if user A has 7 points, then i would like to show 7 lines with the same data and so forth. Please could anyone assist.</P><P></P><P>Thank you in advance.</P><P>Regards</P><P></P><P>Kamiel</P></BODY></HTML> Fri, 30 Nov 2012 11:04:11 GMT https://community.qlik.com/t5/QlikView/Create-Duplicate-rows/m-p/394086#M146947 kamielrajaram 2012-11-30T11:04:11Z Re: Create Duplicate rows https://community.qlik.com/t5/QlikView/Create-Duplicate-rows/m-p/394087#M146948 <HTML><HEAD></HEAD><BODY><P>If doing this in load script, you can try this ...</P><P></P><P><STRONG>Data:</STRONG></P><P><STRONG>Load RowNo() as RowId, * while iterno() &lt;= Score;</STRONG></P><P><STRONG>load * inline [</STRONG></P><P><STRONG>User, Score</STRONG></P><P><STRONG>A,1</STRONG></P><P><STRONG>B,2</STRONG></P><P><STRONG>C,4</STRONG></P><P><STRONG>D,18</STRONG></P><P><STRONG>E,0];</STRONG></P><P></P><P>flipside</P></BODY></HTML> Fri, 30 Nov 2012 11:11:11 GMT https://community.qlik.com/t5/QlikView/Create-Duplicate-rows/m-p/394087#M146948 flipside 2012-11-30T11:11:11Z