Quiz quandry

[Deskin, Bob]

What you want to do is create a subfile with all of the key values from both
the first file and the second. That will take 3 passes in QUIZ. One for each
subfile and then a sort and summary pass. In the last pass link the subfile
to each of the original files in parallel.

Bob Deskin              
Senior Product Advisor, Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 4205 FAX: (613) 228-3149
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA


-----Original Message-----
From: Mike Palandri [mailto:palandri@4j.lane.edu]
Sent: Friday, April 16, 1999 3:43 PM
To: powerh-l@lists.swau.edu
Subject: Quiz quandry


Hi all,

I'm trying to write a report that does not fit into the 
Quiz processing model.  

There are two files with the same keyfield, each with one  
or more records per key value, so for any key value, 
file A could have more records than file B, or vice versa, 
e.g.:

File A:

Key Data
1   aa
1   bb
2   aa
3   aa
3   bb
3   cc
3   dd
4   aa
5   aa
5   bb

File B:

Key Data
1   xx
2   xx
2   yy
3   xx
3   yy
5   xx
5   yy
5   zz


I'd like to report the key and data from each file side by 
side like this (this will look goofy in a proportional font):

     File A   File B
Key  Data     Data
1    aa       xx
     bb

2    aa       xx
              yy

3    aa       xx
     bb       yy
     cc
     dd

4    aa

5    aa       xx
     bb       yy
              zz


If I link on the key field I get a record complex that
contains a number of records that is a multiple if the
records for key values in File A and File B, e.g. for a
key value of "3" the record complex looks like this:


     File A   File B
Key  Data     Data
3    aa       xx
3    aa       yy
3    bb       xx
3    bb       yy
3    cc       xx
3    cc       yy
3    dd       xx
3    dd       yy


In the past I've sorted by either file A data or File B 
data and reported the detail as a "foot at", but as you
can see, that won't work here.

Has anyone had experience with this type of reporting?

Thanks,



Mike
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.