Your workspace contains a Dataflow Gen2 query that displays dimensional product information. The query table contains a column named Product ID/Name that is a concatenation of Product ID and Product Name values. You need to use an applied step in Microsoft Power Query Editor to create a new column for Product ID and Product Name. The solution must use a single command to create two new columns and remove the original combined (Product ID/Name) column. Which applied step should you use?

• A. Merge Columns
• B. Split Column
• C. Change Type
• D. Add Custom Column

Answer: (B)

Splitting a column by a delimiter takes a single text field that contains two values joined together and breaks it into two separate columns in one applied step. In this case, the combined column Product ID/Name is built from Product ID and Product Name separated by a slash. Using Split Column by Delimiter with "/" as the delimiter will produce two new columns—Product ID and Product Name—and replace the original combined column in that same step. That matches the requirement of creating two new columns and removing the original column with a single command.

Merge Columns would do the opposite, turning two columns into one. Change Type would only adjust data types, not create new columns. Add Custom Column would add only one new column (unless you stage multiple steps), but not automatically split the original into two columns in a single operation.