[Download-List] Can Download do... ?

[Jeff Flynt]

Hi Cynthia,

 

This is old, but I'll give a quick two cents in case you never got an
answer... 

 

You can probably do this with an eval statement that calls splice and
splice SA.AWARD to SA.AMOUNT using a either a selected delimiter or
maybe put a value mark in as a delimiter. If you use a specific
delimiter then you would want to wrap a convert around the splice and
convert all instances of the delimiter into a value mark. And because
there could be any number of awards you should use NUM.VALUES ALL after
the eval. So it is probably best to use this field as the last one in a
downloaded statement. 

 

 

HTH,

Jeff Flynt

Arizona State University Foundation | Information Resources Management 
Applications Systems Analyst, Sr.
P.O. Box 875905 | Tempe, Arizona | 85287-5905
PH: 480.965.6870 | Fax: 480.965-6686 | e-mail: jeff.flynt at asu.edu

  <http://www.asufoundation.org/> 

 

 

 

From: download-list-bounces at cedarville.edu
[mailto:download-list-bounces at cedarville.edu] On Behalf Of Jon Wells
Sent: Tuesday, July 03, 2007 8:41 AM
To: download-list at cedarville.edu
Subject: [Download-List] Can Download do... ?

 

Hi all,

Can this be done with out having to create new I-descriptors?  --->

[From our Institutional Researcher]
I need to download student financial aid records. I have no problem
downloading them in each of the following formats:

1.         Student ID         AwardName1 AwardName2 AwardName3
AwardAmount1 AwardAmount2 AwardAmount3

2.         Student ID         AwardName1 AwardAmount1
            Student ID         AwardName2 AwardAmount2
            Student ID         AwardName3 Award Amount3

What I'd like to be able to do is the following:
            Student ID         AwardName1 AwardAmount1 AwardName2
AwardAmount2 AwardName3 AwardAmount3

I know I've done it before - probably using the by.exp and num.subvalues
commands, but I can't remember how to do it for the life of me! {grrrrr}

Can you help? The actual file & field names are below:

File: SA.2006
Fields:  Student ID = SA.STUDENT.ID     
            AwardNames = SA.AWARD (multi-valued field)
          AwardAmounts = SA.AMOUNT (multi-valued field)


Thanks!
Cynthia





*-----------------------------------------------------------*
                          Jon Wells
Database Administrator                         Beloit College
Information Services & Resources           Beloit, Wisconsin
608-363-2290         wellsj at beloit.edu     608-363-2100 (fax)
*-----------------------------------------------------------*

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20070724/e5f5eb84/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.gif
Type: image/gif
Size: 1672 bytes
Desc: image001.gif
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20070724/e5f5eb84/attachment.gif>