topic duplicate records descendingly with While in Featured Members

duplicate records descendingly with While

Luiper — Thu, 03 Aug 2023 13:34:34 GMT

Good morning, I want to double a row of the loaded base depending on the amount of a field by subtracting one unit until it reaches 1, the table is as follows:

LOAD REQ.,
ID,
[BT No.],
[Certificate No.],
Product,
[Number of installments]


I want a loaded line to be duplicated if the [Number of installments]>1 and subtract the number of installments 1 until this subtraction of this field reaches 1.

thank you

Re: duplicate records descendingly with While

maxgro — Thu, 03 Aug 2023 15:31:30 GMT

maybe with iterno()

X:
load * inline [
ID, NumOf
1,1
2,2
3,3
12,2
5,5
];

Y:
load
ID, NumOf, iterno() as N
Resident X
WHILE
IterNo() <= NumOf;

DROP table X;

Re: duplicate records descendingly with While

Luiper — Thu, 03 Aug 2023 20:48:55 GMT

Perfect, I applied the function and it worked for me without problems, thank you very much