Comprehensive and Detailed Explanation From Exact Extract:
In Workday Prism Analytics, a multi-instance field contains multiple values for a single record (e.g., a list of skills for a worker). To convert each instance of a multi-instance field into a single-instance field, you need a transformation that expands the data into multiple rows, with each row containing one instance. According to the official Workday Prism Analytics study path documents, the Explode stage (option B) is the transformation stage designed for this purpose. The Explode stage takes a multi-instance field and creates a new row for each instance, transforming the multi-instance field into a single-instance field in the output. For example, if a worker has three skills in a multi-instance field, the Explode stage will create three rows, each with a single skill value in a single-instance field.
The other options are incorrect:
A. Unpivot: Unpivot transforms columns into rows (e.g., converting wide data to long format), but it does not handle multi-instance fields, which are a specific Workday data type.
C. Manage Fields: The Manage Fields stage modifies field properties (e.g., type, name) but cannot expand a multi-instance field into multiple rows.
D. Group By: The Group By stage aggregates data (e.g., summing values by a key) but does not convert multi-instance fields into single-instance fields.
The Explode stage is the correct transformation to achieve the conversion of a multi-instance field into a single-instance field by expanding the data into multiple rows.
[References:, Workday Prism Analytics Study Path Documents, Section: Data Prep and Transformation, Topic: Handling Multi-Instance Fields with Explode Stages, Workday Prism Analytics Training Guide, Module: Data Prep and Transformation, Subtopic: Converting Multi-Instance Fields to Single-Instance Fields, ]
Submit