Create Duplicate rows

[kamielrajaram]

Good day all,

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.

Thank you in advance.

Regards

Kamiel

[flipside]

If doing this in load script, you can try this ...

Data:

Load RowNo() as RowId, * while iterno() <= Score;

load * inline [

User, Score

A,1

B,2

C,4

D,18

E,0];

flipside