[Download-List] Associated Values on a Line

[Colwell, Kim]

Is it possible to put associated values in different columns on a single
line?

In the following, I would like one line for each student, with the PELL
amount in one column & the FSEOG amount in the next column, but it does not
seem to be working ...

DOWNLOAD SA.<<Enter Award Year (YYYY):>> BY.EXP SA.AWARD \
 @ID \
 SA.LAST \
 SA.FIRST \
 SA.TERM.RES \
 EVAL "IF SA.AWARD = 'PELL' THEN SA.AMOUNT ELSE ''" \
 EVAL "IF SA.AWARD = 'FSEOG' THEN SA.AMOUNT ELSE ''" \
 HEADING \
  LITERAL "Coll_ID" \
  LITERAL "LastName" \
  LITERAL "FirstName" \
  LITERAL "Residency" \
  LITERAL "PELL" \
  LITERAL "FSEOG" \
 FORMAT CSV \
FILE _HOLD_ KCIPEDS-T3_<<Enter Term (YYYYSS):>>.csv OVERWRITING NO.PAGE


Thanks,

Kim Colwell
Danville Area Community College
kcowlell at dacc.edu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20131210/b6cd084a/attachment.html>