QuestionQ21

VerifiedPrepare data

You have a Fabric workspace named Workspace1 that contains a data flow named Dataflow1 contains a query that returns the data shown in the following exhibit.

Question Image

You need to transform the data columns into attribute-value pairs, where columns become rows.

You select the VendorID column.

Which transformation should you select from the context menu of the VendorID column?

Explanation

When you select the VendorID column and need to unpivot the other columns to transform them into attribute-value pairs, you use 'Unpivot other columns.' This transformation keeps the selected column (VendorID) as the key while converting all other columns into rows. 'Unpivot columns' would unpivot only the selected columns, which is the opposite of what's needed.

Community Discussion

No comments yet. Be the first to start the discussion!