Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Traslate intervals into registers


Hi, I need to develop a table with intervals into another table with each register of each interval, something like this:

11-03-2014 12-48-12.png

Any tip please?.

Thanks.

2 Replies
MK_QSL
MVP
MVP

Temp:

Load * Inline

[

  From, To, Tag

  60, 68, pepe

  69, 76, jhon

];

NoConcatenate

Final:

Load

  Tag,

  From+IterNo()-1 as Account

Resident Temp

While From+IterNo()-1 <= To;

Drop Table Temp;

whiteline
Master II
Master II

Hi.

You can also use IntervalMatch statement.

regs:

LOAD

     RowNo()+59 as account

AUTOGENERATE 16;

intervals:

LOAD * INLINE

[ from, to, tag

  60, 68, pepe

  69, 76, jhon

];

linktable:

IntervalMatch(account)

LOAD distinct

     from,

     to

RESIDENT intervals;