[Download-List] Difficulty with WHEN and BY.EXP

[Ohlandt, George W.]

Good afternoon,

I am trying to create a detail, exploded CSV file that only includes rows for certain values of a multi-valued field.    I am attempting to use WHEN with BY.EXP.

TC.USER1 and TC.USER2 have been redefined in the dictionary to be multi-valued and associated.

SELECT TC.2017 WHEN TC.USER1 GT '07/30/17' BY.EXP TC.USER1

DOWNLOAD TC.2017 TC.STUDENT.ID TC.AWARD.ID TC.USER1 TC.USER2 BY.EXP TC.USER1 WHEN TC.USER1 GT '07/30/17'

This works fine EXCEPT when the record only has one value in TC.USER1.  The record is correctly selected and included in the download, but the values for TC.USER1 and TC.USER2 for that record come out null even though the value matches criteria.  If there are more than one value in TC.USER1, then they display as expected...ie just those that meet the WHEN criteria.

Note that if TC.USER1 has more than 1 value, but only 1 meets the WHEN criteria, it DOES display the value correctly

xxx7442,"W0200","09/13/2017",149.63
xxx7442,"W0200","09/27/2017",204.75
xxx7442,"W0200","10/11/2017",183.75
xxx7442,"W0200","10/25/2017",89.25
xxx8421,"W0200","",                    <-TC.USER1 has only 1 value and that value DOES match criteria, but doesn't show
xxx9242,"W0200","09/27/2017",147.00    <-TC.USER1 has multiple values with only 1 matching criteria, and it shows
xxx9890,"W0200","09/27/2017",60.38
xxx9890,"W0200","10/11/2017",139.13

The expected values DO show with a LIST statement.

Has anyone else experienced this?

We are using DOWNLOAD 7.41 on UniData 8.1

Appreciatively,
George

George W. Ohlandt
Executive Director, Enrollment Management
Medical University of South Carolina
843.792.3813
ohlandtg at musc.edu





-------------------------------------------------------------------------
This message was secured via TLS by MUSC.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20171205/57a6b6fc/attachment.html>