How to skip values in for .. next loops

lmonincx — Thu, 22 Feb 2018 08:38:58 GMT

Hi,

I am trying to change my table , which is having a quatity of 1 to 5 into a tabel with single rows for each Quantity

for example

ID QTY

A 1

B 2

C 5

in to

ID QTY

A 1

B 1

C 1

If have the below script working but it is also doing the load for number 3 and 4, I don't want to script running for values which don't exist

any idea, this is just a small example in realtime i have High Qty exceptions ?

vMax=5;

For i = num(1,00) to num($(vMax))
for j= 1 to $(i)

Table:

ID,

QTY

resident x where QTY=$(i);

Re: How to skip values in for .. next loops

tamilarasu — Thu, 22 Feb 2018 08:59:10 GMT

Hi Linda,

Try this,

X:
LOAD ID, 1 as QTY

While IterNo()<= QTY;

LOAD * INLINE [

ID, QTY
A, 1
B, 2
C, 5

];