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?
TDA-C01 Exam QuestionsBrowse all questions from this exam
TDA-C01 Exam - Question 114
Show AnswerHide Answer
Correct Answer:
Discussion
4 commentsLakshmi2023Option: B
Jan 17, 2025Tested. The correct answer is B
2e025afOption: B
Jan 23, 2025Tested, as well
janasureshOption: A
Feb 5, 2025LEFT(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.
ShazzyHawkOption: B
Apr 26, 2025MID([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.