Quiz/QTP help

[Tracy White]

We have been flummoxed at my office by what sounds like it
ought to be easy:

>From a subfileA containing sales data by store and item:
STORE-NO ITEM-NO QTY-SOLD
1                10001    5
2                10003    7
4                10004    6

and a subfileB containing a list of all stores:
1
2
3
4

we wish to create a subfile of all item and store
combinations, with QTY-SOLD = 0 for the 'dummy' records:
STORE-NO ITEM-NO QTY-SOLD
1                10001    5
2                10001    0
3                10001    0
4                10001    0
1                10003    0
2                10003    7
3                10003    0
4                10003    0
1                10004    0
2                10004    0
3                10004    0
4                10004    6

Does anyone have any advice on how to reach this final
state?

PH7.29x on HP3000.

Thanks,
Tracy White

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.