I'm reading a customer order file that lists items and quantities ordered.
Ex: Order # Item qty
1 15 1
2 18 2
However, now I have order # 3 with item 19, which actually consists of item 15 and 18, so I need to append them as item and quantity records.
so - my new file should read:
Ex: Order # Item qty
1 15 1
2 18 2
3 15 1
3 18 2
I'm lost - - - - any help would be appreciated.
Thanks-
Ex: Order # Item qty
1 15 1
2 18 2
However, now I have order # 3 with item 19, which actually consists of item 15 and 18, so I need to append them as item and quantity records.
so - my new file should read:
Ex: Order # Item qty
1 15 1
2 18 2
3 15 1
3 18 2
I'm lost - - - - any help would be appreciated.
Thanks-