Autogenerate from till loop | number - Nummernbereich auffüllen

[robbybalboa]

Hello Group,

I need to create a table for each invoice number but I just have the from and till number (range).

Basistable

Group	From	Till
A	100	105
B	427	434
C	99	99
D	12345	12449

Expected solutioin

Group	Number
A	100
A	101
A	102
A	103
A	104
A	105
B	427
B	428
B	etc

THANK you for your support
Robert

[edwin]

your requirement is very similar to this thread and if you dont have a huge number of records i would recommend Kush's solution:

Solved: Re: hourly breakdown of data - Qlik Community - 1764483

[Kushal_Chawda · Accepted solution]

@robbybalboa  try below

Data:
LOAD Group,
     From + iterno()-1 as Number
FROM Table
While From + iterno()-1 <= To;