Question

A Fabric Analytics Engineer is building a Dataflow Gen2 to load customer data into a lakehouse. The source contains a single column named FullName with values formatted as "LastName, FirstName" (for example, "Smith, John"). The target table requires two separate columns, FirstName and LastName. Which transformation should the engineer apply in the Power Query editor to accomplish this most efficiently?

Accepted Answer

Use Split Column by Delimiter, choosing the comma as the delimiter and splitting into columns

Answer

Use Group By on the FullName column to create the two new columns

Answer

Use Merge Columns to combine FullName with an empty column

Answer

Use Fill Down to populate FirstName and LastName from FullName