View all questions & answers for the TDA-C01 exam
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?
SPLIT([Order_ID], "_", -2)
FINDNTH([Order_ID], "P*", 1)
MID([Order_ID], FIND([Order_ID], "P") + 1, 2)
LEFT(SPLIT([Order_ID], "_", 2), 2)
Submit