Split a single row value into many rows

[iswarya]

Hi All,

I want to split a single row's value into multiple rows.

E.g: For location 11 & item ABC, the qty is 2 so its corresponding fields(NO,DATE,COMMENTS) should be split into next two rows. If the qty is 5 then 5 corresponding rows to be added.

[asinha1991]

you will have to create two nested for loop, one for loop will read qty from each row (using peek function)...and the other will loop till qtv in current iteration and create as many rows

[ArnadoSandoval]

Hi @asinha1991 

This is a duplicated thread, the original one is here 

Regards,