Repeat Rows based on Field

Anonymous — Mon, 04 Jul 2016 15:42:50 GMT

Hello,

I have a table similar to the one noted below. I am trying to replicate / repeat each record in the LOAD script by the number specified in [Months Remaining]:

The input table looks as follows:

TABLE:
LOAD
*
INLINE [
Region, Value, Months Remaining
Canada, 1500, 3

Canada, 700, 1

US 1000, 2];

I would like to have the following output:

Region, Value, Months Remaining
Canada, 1500, 3

Canada, 1500, 3

Canada, 700, 1

US 1000, 2

As such, each record has been repeated and duplicated according to the number of [Months Remaining]. I would really appreciate any help with the code and/ or syntax as I am currently stuck.

Re: Repeat Rows based on Field

tamilarasu — Mon, 04 Jul 2016 16:58:18 GMT

Hi Michael,

Try,

TABLE:
LOAD *
INLINE [
Region, Value, Months Remaining
Canada, 1500, 3
Canada, 700, 1
US, 1000, 2];

Final:
NoConcatenate
LOAD *,

RowNo() as Row
Resident TABLE
While IterNo()<=[Months Remaining];

DROP Table TABLE;

topic Re: Repeat Rows based on Field in QlikView

Repeat Rows based on Field

Re: Repeat Rows based on Field