Returns a record after applying transformations specified in list {1} to {0}. One or more fields may be transformed at a given time.In the case of a single field being transformed, {1} is expected to be a list with two items. The first item in {1} specifies a field name, and the second item in {1} specifies the function to be used for transformation. For example,{{"Quantity", Number.FromText}}
In the case of a multiple fields being transformed, {1} is expected to be a list of lists, where each inner list is a pair of field name and transformation operation. For example,{{{{"Quantity",Number.FromText}},{{"UnitPrice", Number.FromText}}}}
Returns a number value from the given {0}. If the given {0} is null , Number.From returns null . If the given {0} is number ...
Returns a one column table that contains the distinct (unique) values in a column, for a column argument. Or multiple columns ...
Returns a profile for the columns in {0}. The following information is returned for each column (when applicable): minimum ...
Returns a random number greater than or equal to 0 and less than 1, evenly distributed. Random numbers change on recalculation. ...
Returns a record after applying transformations specified in list {1} to {0}. One or more fields may be transformed at a ...
Returns a record after renaming fields in the input {0} to the new field names specified in list {1}. For multiple renames, ...
Returns a record after reordering the fields in {0} in the order of fields specified in list {1}. Field values are maintained ...
Returns a record containing the parts of the given date value, {0}. {0}: A date value for from which the record of its parts ...
Returns a record containing the parts of the given datetime value, {0}. {0}: A datetime value for from which the record of ...