Câu 54: TDA-C01: Tableau Certified Data Analyst

You load a dataset from Microsoft Excel. The following is a sample of the data. FullName contains student names. Some names contain a first name and a last name. Some names contain a first name, a middle name, and a last name. You need to divide FullName into three separate fields: One for the first name, one for the middle name, and one for the last name. The solution must minimize effort. What should you do?

1. A. Use Data Interpreter.
2. B. Use the Split option.
3. C. Use the Custom Split option and specify a space as the delimiter. — đáp án hiện tại
4. D. Use the Custom Split option for the first name and the last name. Create a calculated field that uses a custom function for the middle name.