<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<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.</p>
<p>>>>>>>>>>>>>>>>>>>>>>>></p>
<p>Hope that helps.</p>
<p>Regards<br>
Murray Scholz
</p>
<pre class="moz-signature" cols="72">Agricultural Business Research Institute
University of New England
Armidale NSW 2351 Australia
Email <a class="moz-txt-link-abbreviated" href="mailto:murray.scholz@abri.une.edu.au">murray.scholz@abri.une.edu.au</a> </pre>
<div class="moz-cite-prefix">On 21/08/20 10:00 am, Helen Wellcome
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:MN2PR18MB2399EA79D50B1154D90038E7C95B0@MN2PR18MB2399.namprd18.prod.outlook.com">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<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;}
/* 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]-->
<div class="WordSection1">
<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>
</div>
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>
<fieldset class="mimeAttachmentHeader"></fieldset>
</blockquote>
</body>
</html>