Question

You are preparing survey data in a Dataflow Gen2 destined for a Fabric warehouse dimension table. The source table stores one row per respondent per question, with columns RespondentID, QuestionCode, and Answer. The analysts need a wide table with one row per RespondentID and a separate column for each QuestionCode containing that respondent's Answer. Which transformation should you apply to reshape the data?

Accepted Answer

Pivot the QuestionCode column, using Answer as the values column, and do not aggregate

Answer

Unpivot the QuestionCode and Answer columns to create attribute-value pairs

Answer

Group by RespondentID and count the number of distinct QuestionCode values

Answer

Merge the table with itself on RespondentID to duplicate the answer columns