Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Workday Prism Analytics Exam - Topic 2 Question 6 Discussion

[Data Prep and Transformation]You have to blend two sources of data. Your matching field is Employee ID, which is a text-type field in Pipeline 1, but is numeric in Pipeline 2. How do you prepare your data for blending?
C) Add first a Manage Fields to change the field type and then Join.
A) Add a Manage Fields to change the field type and then Union.
B) Add a Filter first and then a Manage Fields to change the field type.
D) Add a Join first and then a Manage Fields to change the field type.

Workday Prism Analytics Exam - Topic 2 Question 6 Discussion

Actual exam question for Workday's Workday Prism Analytics exam
Question #: 6
Topic #: 2
[All Workday Prism Analytics Questions]

[Data Prep and Transformation]

You have to blend two sources of dat

a. Your matching field is Employee ID, which is a text-type field in Pipeline 1, but is numeric in Pipeline 2. How do you prepare your data for blending?

Show Suggested Answer Hide Answer
Suggested Answer: C

by Vallie at Jun 12, 2025, 05:31 PM

Limited Time Offer

25%

Off

Get Premium Workday Prism Analytics Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Paola
7 months ago
Definitely not option D, that won't work.
upvoted 0 times
...
Willodean
7 months ago
I think option C makes the most sense!
upvoted 0 times
...
Denny
7 months ago
Wait, can you really join different data types like that?
upvoted 0 times
...
Delisa
7 months ago
Isn't it risky to change data types mid-process?
upvoted 0 times
...
Remona
8 months ago
You need to change the field type first before blending.
upvoted 0 times
...
Kallie
8 months ago
I’m confused about the order. I thought we could do a Join first, but now I’m not so sure if that’s the best approach.
upvoted 0 times
...
Lashanda
8 months ago
I vaguely recall that we should always match the data types before performing joins. So, I think option C sounds right to me.
upvoted 0 times
...
Francesco
8 months ago
I'm not entirely sure, but I feel like adding a Filter first might complicate things. I think we usually change the field type before any joins.
upvoted 0 times
...
Nichelle
9 months ago
I remember we practiced something similar where we had to change data types before blending. I think using Manage Fields first makes sense.
upvoted 0 times
...
Harris
9 months ago
Ah, I see the issue - the data types don't match up. I'll need to use a Manage Fields to convert one of them before I can blend the data. Shouldn't be too difficult, just need to remember the right order of the steps.
upvoted 0 times
...
Dyan
9 months ago
Okay, I've got this. I'll use a Manage Fields step to convert the Employee ID field to the same data type, then I can Union or Join the two data sources. Simple!
upvoted 0 times
...
Vashti
9 months ago
Hmm, I'm a bit unsure about this. I think I need to change the field type first, but I'm not sure if I should do that before or after the Union/Join. I'll have to review the module on data prep.
upvoted 0 times
...
Jose
9 months ago
This looks like a tricky one. I'll need to think through the steps carefully to get the data types aligned before blending.
upvoted 0 times
...
Shenika
1 year ago
A) Add a Manage Fields to change the field type and then Union. Easy peasy, just the way I like it. No need to get fancy, folks.
upvoted 0 times
Lilli
12 months ago
Definitely, simplicity is key in data preparation.
upvoted 0 times
...
Tora
12 months ago
I agree, no need to overcomplicate things.
upvoted 0 times
...
Sanda
12 months ago
That's a smart approach, keeping it simple.
upvoted 0 times
...
...
Elly
1 year ago
C) Add first a Manage Fields to change the field type and then Join. Ah, the classic 'transform before joining' approach. Bold move, I like it!
upvoted 0 times
Colby
12 months ago
B) Add a Filter first and then a Manage Fields to change the field type.
upvoted 0 times
...
Veronika
1 year ago
A) Add a Manage Fields to change the field type and then Union.
upvoted 0 times
...
...
Andra
1 year ago
B) Add a Filter first and then a Manage Fields to change the field type. Hmm, I don't know, that seems a bit roundabout. Why not just go with option A and keep it simple?
upvoted 0 times
...
Theron
1 year ago
I see both points, but personally I would choose option D) Add a Join first and then a Manage Fields to change the field type for better data blending.
upvoted 0 times
...
Audry
1 year ago
D) Add a Join first and then a Manage Fields to change the field type. Gotta love a good ol' join before transforming the data. That's the way to do it!
upvoted 0 times
...
Aleta
1 year ago
I disagree, I believe option B) Add a Filter first and then a Manage Fields to change the field type would be more efficient.
upvoted 0 times
...
Gail
1 year ago
I think I would go with option A) Add a Manage Fields to change the field type and then Union.
upvoted 0 times
...
Chantell
1 year ago
A) Add a Manage Fields to change the field type and then Union. Seems like the straightforward solution to me. No need to overcomplicate things.
upvoted 0 times
Dottie
12 months ago
Skye: That could work too, but I prefer the direct approach of A).
upvoted 0 times
...
Arthur
1 year ago
User 3: I would go with B) Add a Filter first and then a Manage Fields to change the field type.
upvoted 0 times
...
Skye
1 year ago
User 2: Agreed, keeping it simple is key in data prep.
upvoted 0 times
...
Mi
1 year ago
User 1: I think A) Add a Manage Fields to change the field type and then Union is the way to go.
upvoted 0 times
...
...

Save Cancel