Unpivot Other Columns in Fabric Dataflow

Transform data

Answer Correct answer: C — Select the VendorID column and choose Unpivot other columns to keep it as an identifier while transforming the remaining columns into rows.

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. 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? -

Group by
Unpivot columns
Unpivot other columns Correct Answer
Split column
Remove other columns

Community Votes

100%

100% of anonymous learners picked answer C. Votes are pick records left by other test-takers — they are not the verified answer.

Community Insight

The question tests Power Query transformation logic: selecting an anchor column and unpivoting the remaining columns requires the 'Unpivot other columns' option, not 'Unpivot columns'.

Learn how to transform data columns into attribute-value pairs in a Microsoft Fabric data flow. Selecting the identifier column and using the 'Unpivot other columns' transformation correctly keeps the key column while pivoting the remaining columns into rows.

Choosing 'Unpivot columns' (B) which would pivot the selected VendorID column instead of the remaining attribute columns.

Community Discussion (5 comments)

Momoanwar 👍 11 Selected: C

Correct

Rakesh16 👍 1 Selected: C

Unpivot other columns

stilferx 👍 3 Selected: C

IMHO, "C", Because of: Unpivot other columns This command unpivots unselected columns. Use this command in a query when not all columns are known. New columns added during a refresh operation are also unpivoted. description is here: https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098#:~:text=Select%20the%20columns%20you%20do,Transform%20%3E%20Unpivot%20Only%20Selected%20Columns.

Nefirs 👍 1 Selected: C

clearly C

XiltroX 👍 3

C is the correct answer

Comments & Corrections

No comments yet — spotted an error or have a note? Share it below.

Expert Analysis

Why the Answer Is Correct

The requirement is to transform columns into attribute-value pairs (rows) while retaining the VendorID column as an identifier. By selecting the VendorID column and choosing 'Unpivot other columns', Power Query keeps VendorID intact and unpivots all other columns into two new Attribute and Value columns. This perfectly matches the stated goal of converting columns to rows for the non-VendorID data.

Why the Other Options Are Wrong

'Group by' aggregates data rather than reshaping it. 'Unpivot columns' would unpivot the selected VendorID column itself, destroying its use as an identifier. 'Split column' divides a single column's values into multiple columns based on a delimiter. 'Remove other columns' deletes unselected columns entirely rather than transforming them into rows.

Community Comment Notes

Users agree that 'Unpivot other columns' is the correct choice because it unpivots the unselected columns while retaining the selected one. As stilferx noted, this command is used 'when not all columns are known' and ensures 'new columns added during a refresh operation are also unpivoted'.

Official Reference

https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098

Exam Strategy

When asked to keep a specific column and transform the rest into rows, select the column to keep and use 'Unpivot other columns'. If you need to unpivot only specific selected columns, use 'Unpivot columns'.

Related Analysis

Practice All DP-600 Questions

Access 115 questions with complete answers and detailed explanations.

View Full DP-600 Practice Test →

← Back to DP-600 Study Guide