Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I resolve two variables: "$(Topic)$(Subject) " side-by-side? I have created a nested For ... Next... loop... . I get an error message and it looks like QV only resolves the 1st one and ignores the other...
Actual Code is:
For each Topic in 'NP' ,'SS'
For each Subject in Math, Reading, Total, Writing
PSAT:
Load
SetID&'-'&num(StudentCode) as KeyfromStudentEW, //PK for entire PA Edmonds App
$(Topic)$(Subject) as PSATScaleScore,
'$(Topic) $(Subject)' as PSATSubjectTemp
Resident PSATTemp
;
Next Subject
Next Topic
Thanks,
Stephanie
Hello Stephanie,
Your second for each line should read
For each Subject in 'Math', 'Reading', 'Total', 'Writing'
All text values must be enclosed in quotes, so it has
'$(Topic)$(Subject)' as PSATSubjectTemp
Because "$(Topic)$(Subject)" is not a name of a field, but a text value. Apart from that, your code seems correct to me.
Regards.
Thank you very much. Can't believe i missed the single quotes for the one "For next" statements... good catch.
Thanks for your response.... my code now works !
Thanks,
Stephanie Lind