Question

An analyst is preparing a customer contact list. The source table stores names in two separate columns, FirstName and LastName, but the marketing team's email tool requires a single FullName field formatted as 'LastName, FirstName'. Which transformation should the analyst apply to produce the required field?

Accepted Answer

Concatenate the LastName and FirstName columns with a comma-and-space separator into a new FullName column

Answer

Parse the LastName column into two substrings based on a delimiter

Answer

Pivot the FirstName and LastName columns from long to wide format

Answer

Normalize the name columns using min-max scaling to a 0-1 range