IBM
000-349 · Question #49
000-349 Question #49: Real Exam Question with Answer & Explanation
The correct answer is B. ="The totals are " + FROMNUMBER (TotalCount, "{#','###}") + "!". The FROMNUMBER function converts a numeric value to formatted text using a pattern string, which is required to produce a thousands-separated output like 2,541.
Question
An application developer is creating a map to produce a report which will include literal text concatenated with a numeric item named TotalCount. Which map rule should the developer use to produce the following line of their report if TotalCount = 2541: The totals are 2,541!
Options
- A="The totals are " + NUMBERTOTEXT (TotalCount) + "!"
- B="The totals are " + FROMNUMBER (TotalCount, "{#','###}") + "!"
- C="The totals are " + CONVERTTOTEXT (TotalCount, "{#','###}") + "!"
- D="The totals are " + NUMBERTOTEXT (TotalCount, "{#','###}") + "!"
Explanation
The FROMNUMBER function converts a numeric value to formatted text using a pattern string, which is required to produce a thousands-separated output like 2,541.
Common mistakes.
- A. NUMBERTOTEXT converts a number to text but does not accept a format pattern argument, so it cannot insert a thousands separator to produce '2,541'.
- C. CONVERTTOTEXT is not a valid map function for numeric-to-text conversion with a format pattern in this mapping tool.
- D. NUMBERTOTEXT does not support a second format argument, making this syntax invalid even though the format pattern itself is correct.
Concept tested. FROMNUMBER function with numeric format pattern
Reference. https://www.ibm.com/docs/en/b2b-integrator/6.1?topic=functions-fromnumber
Community Discussion
No community discussion yet for this question.