Record.ReorderFields

Αναδιατάξετε τα πεδία εγγραφών, ώστε να συμφωνούν με τη σειρά μιας λίστας ονομάτων πεδίων.

Syntax

Record.ReorderFields(
    record as record,
    fieldOrder as list,
    optional missingField as MissingField.Type
) as record

Remarks

Reorders the fields of a record to match the order of a list of field names.

• record: The record containing the fields to reorder.
• fieldOrder: A list containing the new order of the fields to apply to the record. Field values are maintained and fields not listed in this parameter are left in their original positions.
• missingField: Specifies the expected action for missing values in a row that contains fewer fields than expected. The following values are valid:
  • MissingField.Error: (Default) Indicates that missing fields should result in an error. If no value is entered for the missingField parameter, this value is used.
  • MissingField.Ignore: Indicates that missing fields should be ignored.
  • MissingField.UseNull: Indicates that missing fields should be included as null values.

Examples

Example #1

Αναδιατάσσει κάποια από τα πεδία της εγγραφής.

Record.ReorderFields(
    [CustomerID = 1, OrderID = 1, Item = "Fishing rod", Price = 100.0],
    {"OrderID", "CustomerID"}
)

Result:

[OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0]

Example #2

Αναδιατάξτε ορισμένα από τα πεδία της εγγραφής και συμπεριλάβετε null για τυχόν πεδία που λείπουν.

let
    Source = [CustomerID = 3, First Name = "Paul", Phone = "543-7890", Purchase = "Fishing Rod"],
    reorderedRecord = Record.ReorderFields(
        Source,
        {"Purchase", "Last Name", "First Name"},
        MissingField.UseNull
    )
in
    reorderedRecord

Result:

[CustomerID = 3, Purchase = "Fishing Rod", Phone = "543-7890", Last Name = null, First Name = "Paul"]

Category

Record.Transformations