<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<td height="20" BGCOLOR="#005FA8" BORDERCOLOR="#003E6A" align="center" style="border:1px solid #003E6A;">
<a href="http://www.musc.edu/" target="_blank" style="text-decoration: none;"><FONT FACE="ARIAL" COLOR="#FFFFFF"><span style="color: #ffffff; font-family:'Helvetica Neue', Helvetica, Arial, sans-serif; line-height: 20px; font-size:13px; text-shadow: 0px -1px 1px #003E6A; white-space:nowrap;">This message was sent securely by MUSC</span></font></a>
</td>
</tr>
</table>
<BR>
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Good afternoon,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">TC.USER1 and TC.USER2 have been redefined in the dictionary to be multi-valued and associated.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Courier New"">SELECT TC.2017 WHEN TC.USER1 GT ‘07/30/17’ BY.EXP TC.USER1<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Courier New""><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Courier New"">DOWNLOAD TC.2017 TC.STUDENT.ID TC.AWARD.ID TC.USER1 TC.USER2 BY.EXP TC.USER1 WHEN TC.USER1 GT ‘07/30/17’<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Note that if TC.USER1 has more than 1 value, but only 1 meets the WHEN criteria, it DOES display the value correctly<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Courier New"">xxx7442,"W0200","09/13/2017",149.63<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Courier New"">xxx7442,"W0200","09/27/2017",204.75<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Courier New"">xxx7442,"W0200","10/11/2017",183.75<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Courier New"">xxx7442,"W0200","10/25/2017",89.25<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Courier New"">xxx8421,"W0200","", <-TC.USER1 has only 1 value and that value DOES match criteria, but doesn’t show<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Courier New"">xxx9242,"W0200","09/27/2017",147.00 <-TC.USER1 has multiple values with only 1 matching criteria, and it shows<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Courier New"">xxx9890,"W0200","09/27/2017",60.38<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Courier New"">xxx9890,"W0200","10/11/2017",139.13<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The expected values DO show with a LIST statement.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Has anyone else experienced this? <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">We are using DOWNLOAD 7.41 on UniData 8.1<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Appreciatively,<o:p></o:p></p>
<p class="MsoNormal">George<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">George W. Ohlandt<o:p></o:p></p>
<p class="MsoNormal">Executive Director, Enrollment Management <o:p></o:p></p>
<p class="MsoNormal">Medical University of South Carolina <o:p></o:p></p>
<p class="MsoNormal">843.792.3813 <o:p></o:p></p>
<p class="MsoNormal">ohlandtg@musc.edu<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>
<BR>
<BR>
<BR>
-------------------------------------------------------------------------
<BR>
<font face="arial" color="#000000" size="2">This message was secured via TLS by <strong><a
href="http://www.musc.edu"><font color="#0038A8">MUSC</font></a></strong>.</font>