A QUIZ Problem/Challenge

[Lindley HILL]

You need something like the following:

access input_subfile

subfile sf1 keep if desc1 <> " " include &
po, &
line, &
desc1 alias desc

subfile sf1 alias sf2 keep append if desc2 <> " " include &
po, &
line, &
desc2 alias desc

etc., with a subfile statement for each description occurrence.

Hope that helps.

Lindley

Lindley Hill
NSW Health Dept
Sydney, Aust
(02) 9391 9726

>>> "Karman, Al" <AKarman@USFreightways.com> 08/12/00 8:00:46 >>>
Greetings to the list.....this is one of those that's probably got a
painless solution...

I have a subfile setup like this:
PO#/LINE#/Description 1 ... Description 21

Which gives me a unique record for each PO#/LINE#

Now, the problem/challenge.  First, for the description 1/description 21,
they may not all be populated (always consecutive, may get desc1 => desc9,
next record desc 1 => desc5).

Here it comes....I'm looking for a fairly elegant way to 
	- Have 1x read to the subfile, and
	- Have that produce anywhere from 1 to 21 UNIQUE new subfile entries
I can          	  then use to QTP them into a dataset which describes the
PO#/LINE#

e.g. 
RECORD#1 from input file....

PO#123/LINE#6789/'This product'/'can be used'/'to remove the hair'/'growing
on your palms'

would create 4x records like
PO#123/LINE#6789/'This product'
PO#123/LINE#6789/'can be used'....

You get the picture....!  I also need a counter to increment but I can
figure that out...!

I'm fooling with stuff like defining fields as blank based upon description
n = spaces, etc. but I'm also thinking there's gotta be Something out
there.....

A BIG Thanks in Advance to all respondents!

Al Karman
IT Consultant
US Freightways 
akarman@usfreightways.com 
773.824.2284

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

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