Create the GetStudents Transformation Procedure
The GetStudents transformation is a simple procedure that will get used as part of a larger XML schema mutation transformation. The following graphic shows the goal for this task:
To create the GetStudents transform
1. Open Studio.
2. In the Studio resource tree, select Shared.
3. Right-click and select New Transformation.
4. Select Any-Any Transformation and click Next.
5. Type GetStudents in the Transformation Name field.
6. Click Finish.
The Transformation Editor opens with the Model tab displayed.
7. Click the in container.
8. Right-click and select Add Parameter.
9. Select Browse.
10. Browse to the schoolDefinitions definition set.
11. Select Classes.
12. Click OK.
13. Save your transform.
14. From the palette, click and drag Loop onto the editor.
15. Draw a connection from school:Class to source on loop.
16. Click loop to make sure it is selected.
17. Right-click and select Add Source.
18. Draw a connection from school:Student to source on loop.
19. From loop draw a connection from Student to out.
Out will be populated with an array for the Student element.
20. Connect loop :school:StudentName to out: school:StudentName.
21. Connect loop :school:StudentEmail to out: school:StudentEmail
22. Save the transform.
