having issues using index for a file

[Helen Wellcome]

I have been coding with qtp for many years but am having a brain-lock.

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.
I wanted to take this file and create a file with    student_num    email1    email2   (one record for the student)


set process nolimit
> access google_students_201920 alias xwork
> sort on student_num
> define xemail1 char*45 = email
> define xemail2 char*45 = " "
> subfile xsthelnetestgoogle at student_num index student_num keep include student_num, xemail1, xemail2
                                            ^^^^^
*E* Expected:  .  OF  PORTABLE  FORMAT  <eol>  ALIAS  AT  IF  ON  APPEND
      NOAPPEND  KEEP  TEMPORARY  DICTIONARY  NODICTIONARY  INCLUDE

If there was no error I then had setup:
Access google_students_201920 alias xwork &
Link student_num of xwork to student_num of *xsthelentestgoogle alias xtemp
Select if email of xwork <> xemail1 of xtemp
Output *xsthelentestgoogle update
Item xemail2 of *xsthelentestgoogle final email

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20200821/ca99f308/attachment.html>