Joined: 22 Apr 2021 Posts: 7 Location: United States
Dear Sir,
I am trying to pull or extract data using multiple 'AND'/'OR' condition in single INCLUDE condition in SORT for the below requirement, but not getting the expected out come.
The data in Input file formed such a way that, for each 'A10' record there would be 1 or multiple 'A11' records with 'Pass' (P) or 'Fail' (F) indicator on subjects. Requirement is, I need to find out, how many 'A11' records are having 'P' status for specific 'SNO'.
As per the sample input data provided above, there are 4 'A10' records with one or more 'A11' records under it. I wanted to pull out data of all 'A11' records that are having 'P' status for only Students (SNO) being '1001' & '1002'. Just to minimize number of input records as an example purpose, i have provided only two SNO's, but actually I need to pull this data for around 20 students in the volume of 1500 students.
As 'OR' condition for 'A11' not proper here its pulling 'A11' records for SNOs 2001 & 2002 as well which is not needed. Please provide some light on this.
Joined: 22 Apr 2021 Posts: 7 Location: United States
Dear Joerge,
Thank you for your help providing information on this.
Could you please clarify me on reason for using starting position as '49' in INCLUDE condition. Because our SNO starts in position '10' in 'A10' record. Just trying to understand for any specific purpose to have as '49'. When I run it, getting empty output file. Please advise.