Forum Discussion
Dicken
Post Prodigy
Post ProdigySorting Records
I wanted a way to sort a records without converting to a table ; I came up with this , if anyone has better solution or improvement I would be interested. let
rec = [ B = "abc", E = ...
You can try this...
let rec = [ B = "abc", E = 12, D = "def", C = 10 , A = 5], sortFields = List.Sort(Record.FieldNames(rec)), sortRecord = Record.ReorderFields(rec, sortFields, MissingField.Ignore) in sortRecordjust to add, i did not know there was a re order , there are just so many m functions it's frightening.
