Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Repeating number of Rows

Hi Guys

I have a table as Follows:

DimensionCodeToFrom
1A13
1B68

and i want the output as

DimensionCodeToFromRange
1A131
1A132
1A133
1B686
1B687
1B688
1 Solution

Accepted Solutions
Gysbert_Wassenaar

Something like this:

Result:

load DimensionCode, To, From, To + iterno() -1 as Range

from ...somewhere...

while To + iterno() -1 <= From;


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

Something like this:

Result:

load DimensionCode, To, From, To + iterno() -1 as Range

from ...somewhere...

while To + iterno() -1 <= From;


talk is cheap, supply exceeds demand