Workday Pro Integrations Certification Exam Workday-Pro-Integrations Question # 3 Topic 1 Discussion

In Workday integrations, XSLT is used to transform XML data, such as the output from a web service-enabled report or EIB, into a desired format for third-party systems. In this scenario, you need to create an XSLT template that matches the wd:Education_Group element in the provided XML and transforms it to produce the degree data in the format shown in the Transformed_Record example. The goal is to output each degree (e.g., "California University MBA" and "Georgetown University B.S.") as a element within a parent element.

Here’s why option A is correct:

Template Matching: The correctly targets the wd:Education_Group element in the XML, which contains multiple wd:Education elements, each with a wd:Degree child, as shown in the XML snippet (e.g., California UniversityMBA).

Transformation Logic:

creates the outer element for each education group, matching the structure in the Transformed_Record example (e.g., California University MBA).

copies the content of the child elements (wd:Education and wd:Degree) and concatenates their values into a single string. The select="*" targets all child elements of wd:Education_Group, and xsl:value-of outputs their text content (e.g., "California University" and "MBA" become "California University MBA").

This approach ensures that each wd:Education_Group is transformed into a single element with the combined text of the wd:Education and wd:Degree values, matching the example output.

Context and Output: The template operates on each wd:Education_Group, producing the nested structure shown in the Transformed_Record (e.g., CaliforniaUniversity MBAGeorgetown University B.S.), assuming a parent template or additional logic wraps the elements in .

Why not the other options?

B.

xml

WrapCopy

This uses without , which outputs the concatenated text of all child elements but does not preserve any XML structure or formatting. It would produce plain text (e.g., "California UniversityMBACalifornia UniversityB.S.") without the proper tags, failing to match the structured output in the example.

C.

xml

WrapCopy

This uses , but does not take a select attribute—it simply copies the current node. This would result in an invalid XSLT syntax and fail to produce the desired output, making it incorrect.

D.

xml

WrapCopy

This uses , which copies all child nodes (e.g., wd:Education and wd:Degree) as-is, including their element structure, resulting in output like California UniversityMBA. This does not match the flattened, concatenated text format in the Transformed_Record example (e.g., California University MBA), making it incorrect.

To implement this in XSLT for a Workday integration:

Use the template from option A to match wd:Education_Group, apply to concatenate and output the wd:Education and wd:Degree values as a single element. This ensures the transformation aligns with the Transformed_Record example, producing the required format for the integration output.

References:

Workday Pro Integrations Study Guide: Section on "XSLT Transformations for Workday Integrations" – Details the use of , , and for transforming XML data, including handling grouped elements like wd:Education_Group.

Workday EIB and Web Services Guide: Chapter on "XML and XSLT for Report Data" – Explains the structure of Workday XML (e.g., wd:Education_Group, wd:Education, wd:Degree) and how to use XSLT to transform education data into a flattened format.

Workday Reporting and Analytics Guide: Section on "Web Service-Enabled Reports" – Covers integrating report outputs with XSLT for transformations, including examples of concatenating and restructuring data for third-party systems.