Skip to Content
0
Former Member
Sep 06, 2011 at 06:58 PM

Repeat Rows based on another field

18 Views

Hello Experts,

Can anyone help with me a query from delivery document to repeat rows based on another field:

Ex: Say, i have an item qty 10 on line 1 , i am looking to repeat 10 rows each with qty 1.

What i have

ItemCode Qty

A0001 10

What i need:

ItemCode Qty

A0001 1

A0001 1

A0001 1

A0001 1

A0001 1

A0001 1

A0001 1

A0001 1

A0001 1

A0001 1