
Answer-first summary for fast verification
Answer: Unpivot other columns
To transform the data columns into attribute-value pairs, where columns become rows, you should use the 'Unpivot other columns' transformation. This option will convert the selected columns into attribute-value pairs by unpivoting all other columns, effectively turning the columns into rows.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are managing a Fabric workspace named Workspace1. Within this workspace, there's a data flow named Dataflow1, which includes a query that retrieves data. The task at hand involves transforming the structure of this data. Specifically, you need to convert the data columns into attribute-value pairs, effectively turning columns into rows for better data manipulation and analysis. You have chosen the VendorID column to start this transformation process. Which transformation option should you choose from the context menu of the VendorID column to accomplish this?
A
Group by
B
Unpivot columns
C
Unpivot other columns
D
Split column
E
Remove other columns
No comments yet.