TDS-C01 Exam QuestionsBrowse all questions from this exam

TDS-C01 Exam - Question 19


You have the following string value: Sales Data.

Which calculated field produces an output of Sales?

Show Answer
Correct Answer: AB

To extract the substring 'Sales' from 'Sales Data', the LEFT function needs to specify the number of characters to return. The syntax LEFT(“Sales Data”, 5) properly extracts the first five characters, which is 'Sales'. Other options such as LEFT(“Sales Data”) lack the required length argument, and LTRIM or RTRIM functions are used for trimming spaces from strings, not extracting specific substrings.

Discussion

12 comments
Sign in to comment
AisiahOption: B
Nov 11, 2022

Left('Sales Data',5)

sru_basanisOption: B
Dec 11, 2022

https://help.tableau.com/current/pro/desktop/en-us/functions_functions_string.htm

Mati0186Option: B
Jan 3, 2023

Correct answer is B--> Left('Sales Data',5)

mskuntOption: B
Apr 2, 2023

LEFT (“Sales Data”, 5)

Juan86Option: B
Feb 20, 2024

Answer: B LEFT function and the number 5 due to Sales has 5 positions

sylwus1611Option: B
Apr 19, 2024

B is correct, A lacks of an argument

Mahammad123Option: B
Dec 23, 2022

B IS THE CORRECT ANSWER

BanderMansorOption: B
Feb 13, 2023

wrong answer, B is correct

PriyadsOption: B
Feb 24, 2023

B is the right answer

RweenOption: B
Jun 21, 2023

LEFT ([FieldName], 7)

MonBoujOption: B
Nov 23, 2023

B. LEFT (“Sales Data”, 5)

Yaya93Option: B
Jan 11, 2024

Answer : B