Insert Data based on Values Difference

[ahmar811]

Dear Experts,

This are my tables

Table:

Group	From	To
A	254	254
B	884	884
C	562	568
D	586	586
E	248	248
F	157	159

For Group C there is difference 568-562=6 so we have to populate 6 rows for group C as starting from 562 to 568 i,e 562,563......568

The required Result is as follows.

Result Table:

Group	From	To
A	254	254
B	884	884
C	562	562
C	563	563
C	564	564
C	565	565
C	566	566
C	567	567
C	568	568
D	586	586
E	248	248
F	157	157
F	158	158
F	159	159

"I want to do this in the Load Script (Backend)"

Thanks & Regards

Ahmar

[lironbaram · Accepted solution]

hi

this script should do the trick

Table:

load Group,

     From +IterNo()-1 AS From,

     From +IterNo()-1 AS To

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

load * inline [

Group,From,To

A,254,254

B,400,400

C,562,568

];