Record.Combine Function in Power Query

The Record.Combine function combines the records in a list. If the field names are repeat in the multiple records, then the value in the last record for that filed in which it appears is mapped to the filed value.

Syntax

Record.Combine(records as list) as record

Example: Create a combined record from the records.

Power Query M

let
    Source = Record.Combine({
    [CustomerID = 1, Name = "Ashish", Phone = "123-4567", Company = "TCS"], 
    [Name = "Esha", Company = "Google", Salary = 70000]
    })
in
    Source

The output of the above code is shown below:

Previous Next