Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@robbybalboa try below
Data:
LOAD Group,
From + iterno()-1 as Number
FROM Table
While From + iterno()-1 <= To;
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
@robbybalboa try below
Data:
LOAD Group,
From + iterno()-1 as Number
FROM Table
While From + iterno()-1 <= To;