Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I need to develop a table with intervals into another table with each register of each interval, something like this:
Any tip please?.
Thanks.
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;
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;