What should you do?

You have a CSV file that contains user complaints. The file contains a column named Logged logged contains the date and time each complaint occurred. The data in Logged is m the following format: 2018-12-31 at 08:59.

You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.

What should you do?
A . Create a column by example that starts with 2018-12-31.
B. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date
C. Apply the parse function from the Date transformations options to the Logged column.
D. Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number.

View Answer

Answer: D