ExamTopics Logo
Mail Us[email protected]
Menu
Tableau Discussions
exam questions

Exam TDA-C01 All Questions

View all questions & answers for the TDA-C01 exam
Go to Exam

Exam TDA-C01 topic 1 question 199 discussion

Actual exam question from Tableau's TDA-C01
Question #: 199
Topic #: 1
[All TDA-C01 Questions]

Below are some of the values in the Order_ID field.



Which calculation should a Data Analyst use to return the two letter combinations starting with the letter P for each of these values?

  • A. LEFT(SPLIT([Order_ID], "_P", 2), 2)
  • B. MID([Order_ID], FIND([Order_ID],"_P") + 1, 2)
  • C. FINDNTH([Order_ID], "P\*", 1)
  • D. SPLIT([Order_ID], "_", -2)
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by Lakshmi2023 at Jan. 17, 2025, 6:15 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
ShazzyHawk
6 days, 19 hours ago
Selected Answer: B
MID([Order_ID], FIND([Order_ID], "_P") + 1, 2) FIND("_P") locates _P +1 shifts right to "P" MID(..., 2) grabs two characters from "P" onwards More stable and safe.
upvoted 1 times
...
janasuresh
2 months, 3 weeks ago
Selected Answer: A
LEFT(SPLIT([Order_ID], "_P", 2), 2): eg: Split the Id using '_P' it forms two part C_123 and _PZ_2. from this take the 2nd part and use LEFT function and get first 2 word.
upvoted 1 times
...
2e025af
3 months, 1 week ago
Selected Answer: B
Tested, as well
upvoted 1 times
...
Lakshmi2023
3 months, 2 weeks ago
Selected Answer: B
Tested. The correct answer is B
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago