Insert Data based on Values Difference

ahmar811 — Tue, 03 Jan 2017 09:35:17 GMT

Dear Experts,

This are my tables

Table:

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:

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

Thanks & Regards

Ahmar

Re: Insert Data based on Values Difference

lironbaram — Tue, 03 Jan 2017 10:04:04 GMT

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

];