Record.Combine
Several records merged into one; where two have the same field, the later record's value wins.
Group: Record. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Record.Combine(records as list) as record| Parameter | Type | Description |
|---|---|---|
records | list | The records to merge, in order. |
Returns
record. Every field of every record, each name once.
Remarks
- A field keeps the place where it first appeared; only its value changes.
Examples
An order and its status
Record.Combine({[Order = 1001, Shop = "Oslo"], [Status = "Shipped"]})[Order = 1001, Shop = "Oslo", Status = "Shipped"]An update over an old value
Record.Combine({[Order = 1001, Status = "Open", Shop = "Oslo"], [Status = "Shipped"]})[Order = 1001, Status = "Shipped", Shop = "Oslo"]