MENU
[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?
Suggested Answer: C
Get Premium Workday Prism Analytics Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
30 comments · newest first
PA
Paola
10 months ago
Definitely not option D, that won't work.
WI
Willodean
10 months ago
I think option C makes the most sense!
DE
Denny
10 months ago
Wait, can you really join different data types like that?
DE
Delisa
10 months ago
Isn't it risky to change data types mid-process?
RE
Remona
11 months ago
You need to change the field type first before blending.
KA
Kallie
11 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.
LA
Lashanda
11 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.
FR
Francesco
11 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.
NI
Nichelle
12 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.
HA
Harris
12 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.
DY
Dyan
12 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!
VA
Vashti
1 year 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.
JO
Jose
1 year ago
This looks like a tricky one. I'll need to think through the steps carefully to get the data types aligned before blending.
SH
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.
LI
Lilli
1 year ago
Definitely, simplicity is key in data preparation.
TO
Tora
1 year ago
I agree, no need to overcomplicate things.
SA
Sanda
1 year ago
That's a smart approach, keeping it simple.
EL
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!
CO
Colby
1 year ago
B) Add a Filter first and then a Manage Fields to change the field type.
VE
Veronika
1 year ago
A) Add a Manage Fields to change the field type and then Union.
AN
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?
TH
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.
AU
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!
AL
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.
GA
Gail
1 year ago
I think I would go with option A) Add a Manage Fields to change the field type and then Union.
CH
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.
DO
Dottie
1 year ago
Skye: That could work too, but I prefer the direct approach of A).
AR
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.
SK
Skye
1 year ago
User 2: Agreed, keeping it simple is key in data prep.
MI
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.