<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 15 (filtered medium)">
<title>Page Title</title>
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 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;
color:black;}
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;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
color:black;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Consolas",serif;
color:black;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@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 bgcolor="white" lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:windowtext">Didn’t work<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext">I believe I had tried that before. But I re-tried<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext">I would have thought it would have worked. Don’t know why its being so picky<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext;background:yellow;mso-highlight:yellow">set process nolimit<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext;background:yellow;mso-highlight:yellow">> access google_students_201920 alias xwork<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext;background:yellow;mso-highlight:yellow">> sort on student_num<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext;background:yellow;mso-highlight:yellow">> define xemail1 char*45 = email<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext;background:yellow;mso-highlight:yellow">> define xemail2 char*45 = " "<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext;background:yellow;mso-highlight:yellow">> subfile xsthelentestgoogle keep at student_num include student_num, xemail1, xemail2 index student_num<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext;background:yellow;mso-highlight:yellow">*E* Item specified for index/segment not part of subfile include list.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext;background:yellow;mso-highlight:yellow">> go</span><span style="color:windowtext"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="color:windowtext">From:</span></b><span style="color:windowtext"> Murray Scholz <murray.scholz@abri.une.edu.au>
<br>
<b>Sent:</b> Thursday, August 20, 2020 8:15 PM<br>
<b>To:</b> powerh-l@lists.sowder.com; Helen Wellcome <HWellcom@wsboces.org><br>
<b>Subject:</b> [EXTERNAL] Re: having issues using index for a file<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p style="background:fuchsia"><b>** Warning! External Email! ** <o:p></o:p></b></p>
<div>
<p>Hello Helen,<br>
I think it's just complaining about the syntax of your subfile statement. Put the "index student_num" at the end, after your list of items.<br>
eg.<br>
> access parameters<br>
> sort on file-type<br>
> define a1 char*60 = param-descript<br>
> define a2 char*60 = " "<br>
> subfile xxxyyyzzz keep at file-type include file-type,a1,a2 index file-type<br>
> go<br>
<br>
Executing request 1 ...<br>
<br>
Records read:<br>
PARAMETERS 110<br>
<br>
Transactions processed: 110<br>
<br>
Records processed: Added Updated Unchanged Deleted<br>
XXXYYYZZZ 27 0 0 0<br>
<br>
Finished.<o:p></o:p></p>
<p>>>>>>>>>>>>>>>>>>>>>>>><o:p> </o:p></p>
<p>Hope that helps.<o:p></o:p></p>
<p>Regards<br>
Murray Scholz <o:p></o:p></p>
<pre>Agricultural Business Research Institute<o:p></o:p></pre>
<pre>University of New England<o:p></o:p></pre>
<pre>Armidale NSW 2351 Australia<o:p></o:p></pre>
<pre>Email <a href="mailto:murray.scholz@abri.une.edu.au">murray.scholz@abri.une.edu.au</a> <o:p></o:p></pre>
<div>
<p class="MsoNormal">On 21/08/20 10:00 am, Helen Wellcome wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal">I have been coding with qtp for many years but am having a brain-lock.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">I have a file of students with emails. There are some students with 2 records and has caused problems on one of the reports , by listing a course twice.<o:p></o:p></p>
<p class="MsoNormal">I wanted to take this file and create a file with student_num email1 email2 (one record for the student)<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">set process nolimit<o:p></o:p></p>
<p class="MsoNormal">> access google_students_201920 alias xwork<o:p></o:p></p>
<p class="MsoNormal">> sort on student_num<o:p></o:p></p>
<p class="MsoNormal">> define xemail1 char*45 = email<o:p></o:p></p>
<p class="MsoNormal">> define xemail2 char*45 = " "<o:p></o:p></p>
<p class="MsoNormal">> subfile xsthelnetestgoogle at student_num index student_num keep include student_num, xemail1, xemail2<o:p></o:p></p>
<p class="MsoNormal"> ^^^^^<o:p></o:p></p>
<p class="MsoNormal">*E* Expected: . OF PORTABLE FORMAT <eol> ALIAS AT IF ON APPEND<o:p></o:p></p>
<p class="MsoNormal"> NOAPPEND KEEP TEMPORARY DICTIONARY NODICTIONARY INCLUDE<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">If there was no error I then had setup:<o:p></o:p></p>
<p class="MsoNormal">Access google_students_201920 alias xwork &<o:p></o:p></p>
<p class="MsoNormal">Link student_num of xwork to student_num of *xsthelentestgoogle alias xtemp<o:p></o:p></p>
<p class="MsoNormal">Select if email of xwork <> xemail1 of xtemp<o:p></o:p></p>
<p class="MsoNormal">Output *xsthelentestgoogle update<o:p></o:p></p>
<p class="MsoNormal">Item xemail2 of *xsthelentestgoogle final email<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">CONFIDENTIALITY NOTICE: The information contained in this message is confidential, and is intended only for the addressee. If the reader of this message is not the intended recipient, or employee or agent responsible for delivering it to
the intended recipient, you are hereby notified that dissemination, distribution, or copying of this communication or any of its content is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us promptly
at (631) 549-4900 and destroy the email and any copies. <br>
<br>
<o:p></o:p></p>
</blockquote>
</div>
</div>
</body>
</html>