[Download-List] Picking specific values in multi-valued field

[Jeffery G. Summers]

That, I think, will do the trick!  I've used that only once before and
completely forgot about it.  I need to get a new copy of the DOWNLOAD help
pdf too!  Thanks Don!

 

From: download-list-bounces at cedarville.edu
[mailto:download-list-bounces at cedarville.edu] On Behalf Of Don Prezioso
Sent: Thursday, May 26, 2011 4:49 PM
To: Cedarville DOWNLOAD Users
Subject: Re: [Download-List] Picking specific values in multi-valued field

 

Jeffery,

 

I'm not sure I understand the exact problem, but couldn't you use
NUM.VALUES 2 VALUE.SEPARATOR "*"?

 

Don

 

--

Donald Prezioso

Director of Administrative I.T.

Ashland University

Ashland, Ohio

  _____  

From: download-list-bounces at cedarville.edu
[download-list-bounces at cedarville.edu] On Behalf Of Jeffery G. Summers
[jsummers at transy.edu]
Sent: Thursday, May 26, 2011 4:32 PM
To: Download
Subject: [Download-List] Picking specific values in multi-valued field

I've not done this before using DOWNLOAD.and if it is do-able, what's the
best method?

 

I need to create an extract for a 3rd party with the primary file being
STUDENT.ACAD.CRED.  I need to pull in from COURSE.SECTIONS the
SEC.XLIST.COURSE.SECTIONS field.  However, I can't just use NUM.VALUES 2
(or ALL).  The data spec wants the field to be
PrimarySectionId*SecondarySectionId.  I know I can massage the data in
Excel after-the-fact or create a computed column but would like to create
as few extra steps/computed columns as possible. 

 

Suggestions?  Thanks!

 

 

Regards,

 

Jeffery G. Summers
Administrative Computing
Transylvania University
Office: 859-233-8134
Direct: 859-233-8139 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20110526/55b0f459/attachment.html>