Power Query
Search…
published
Introduction
Accessing Data
Action
Binary
Binary Formats
Combiner
Comparer
Cube
Date
Date Time
Date Time Zone
Diagnostics
Duration
Error
Expression
Function
Lines
List
Logical
Metadata
Number
Record
Record.AddField
Record.Combine
Record.Field
Record.FieldCount
Record.FieldNames
Record.FieldOrDefault
Record.FieldValues
Record.FromList
Record.FromTable
Record.HasFields
Record.RemoveFields
Record.RenameFields
Record.ReorderFields
Record.SelectFields
Record.ToList
Record.ToTable
Record.TransformFields
Replacer
Splitter
Table
Text
Time
Type
Uri
Values
Powered By GitBook
Record.RemoveFields

Record.RemoveFields

Removes the specified field(s) from the input record.
function (record as record, optional fields as nullable any, optional missingField as nullable any) as record

Description

Returns a record that removes all the fields specified in list fields from the input record. If the field specified does not exist, an exception is thrown.

Category

Record.Transformations

Examples

Remove the field "Price" from the record.
Record.RemoveFields([CustomerID=1, Item = "Fishing rod", Price=18.00], "Price")
[CustomerID=1, Item="Fishing rod"]
Remove the fields "Price" and "Item" from the record.
Record.RemoveFields([CustomerID=1, Item = "Fishing rod", Price=18.00], {"Price", "Item"})
[CustomerID=1]
Previous
Record.HasFields
Next
Record.RenameFields
Last modified 3yr ago
Copy link
Outline
Record.RemoveFields
Description
Category
Examples