topic Re: Split a single row value into many rows in App Development

Split a single row value into many rows

iswarya — Fri, 24 Apr 2020 09:22:50 GMT

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.

Re: Split a single row value into many rows

asinha1991 — Fri, 24 Apr 2020 10:19:08 GMT

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

Re: Split a single row value into many rows

ArnadoSandoval — Tue, 28 Apr 2020 11:23:43 GMT

Hi @asinha1991

This is a duplicated thread, the original one is here

Regards,