Tableau Desktop Specialist — Question 135

In a dataset, a Data Analyst has a string field named Category that contains unnecessary trailing spaces.

Which function should the analyst use to remove the trailing spaces from the Category field?

Answer options

• A. SPLIT
• B. RTRIM
• C. REPLACE
• D. LTRIM

Correct answer: B

Explanation

The RTRIM function is specifically designed to remove trailing spaces from a string, making it the correct choice for this situation. The other options, such as LTRIM, only remove leading spaces, while SPLIT and REPLACE do not directly address the removal of trailing spaces.