WORKDAY-PRO-INTEGRATIONS practice question 12 of 15

You have a population of workers who have put multiple names in their Legal Name - First Name Workday delivered field. Your third-party vendor only…

You have a population of workers who have put multiple names in their Legal Name - First Name Workday delivered field. Your third-party vendor only accepts one-word first names. For workers that have included a middle name, the first and middle names are separated by a single space. You have been asked to implement the following logic: * Extract the value before the single space from the Legal Name - First Name Workday delivered field. * Count the number of characters in the extracted value. * Identify if the number of characters is greater than. * If the count of characters is greater than 0, use the extracted value. Otherwise, use the Legal Name - First Name Workday delivered field. What functions are needed to achieve the end goal?

Answer options

A: Extract Single Instance, Text Length, Numeric Constant, True/False Condition

B: Text Constant, Substring Text, Arithmetic Calculation, Evaluate Expression

C: Format Text, Convert Text to Number, True/False Condition, Evaluate Expression

D: Substring Text, Text Length, True/False Condition, Evaluate Expression Correct answer

Correct Answer:

D. Substring Text, Text Length, True/False Condition, Evaluate Expression

Explanation

This solution requires a sequence of functions to meet the specified logic. First, Substring Text is used to extract the portion of the string before the space (the first name). Second, Text Length calculates the number of characters in this extracted value. Third, a True/False Condition is used to evaluate if the character count is greater than zero. Finally, Evaluate Expression acts as an if-then-else statement, using the output of the True/False Condition to decide whether to return the newly extracted first name or the original, unmodified field value. This combination directly addresses all requirements of the problem.

Why Incorrect

A: This option is incomplete as it lacks the Evaluate Expression function needed to perform the final conditional "if-then-else" logic. B: Arithmetic Calculation is incorrect; it is used for mathematical operations (e.g., addition, subtraction), not for logical comparisons like "greater than". C: Format Text and Convert Text to Number are inappropriate. Format Text alters display, and Convert Text to Number is for numeric strings, not names.

References

1. Workday Community

"Calculated Fields Reference Guide": This official documentation details the functions available for creating calculated fields.

Substring Text: Described under "Text Functions

" this function is used to return a portion of a text string based on a starting position and length. This is essential for the initial extraction.

Text Length: Also under "Text Functions

" this function returns the number of characters in a specified text field

fulfilling the counting requirement.

True/False Condition: Found in the "Logical Functions" section

it is used to create a boolean (true/false) result based on comparing values

such as checking if the text length is greater than a numeric constant.

Evaluate Expression: Detailed under "Logical Functions

" this function returns a specific value based on the result of one or more conditional statements

making it the correct choice for the final if-then-else logic.

Keep practicing

Take the free WORKDAY-PRO-INTEGRATIONS practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.

Start the free practice test