Basic Transformation Options

the table shows advanced transformation options, summary and provides easy to copy/paste examples want to write the code yourself? you can use advanced transformations to write complex jsonata expressions, which gives you significant flexibility to transform data according to your needs see jsonata docs https //docs jsonata org/overview\ html to assist you in writing expressions for the list of context variables, see context variables docid\ ulk0z zxhuatvy90alrw8 array transformation flatten flatten an array containing potentially nested arrays to a single array example pluckby extract the values of a property or deeply nested property of the objects within an array of objects example sort sort the items of an array of strings or numbers by value example sortby sort the items of an array of objects by the value of a plucked property of the objects within the array example countif count all items of an array that are equal to a specific value example countifby count all items of an array of objects that contain a plucked property equal to a specific value example sum sum the values of an array of numbers example sumby sum the values of a plucked property of the objects within an array of objects example avg average the values of an array of numbers example avgby average the values of a plucked property of the objects within an array of objects example min find the minimum value in an array of numbers example minby find the minimum value of a plucked property of the objects within an array of objects example max find the maximum value in an array of numbers example maxby find the maximum value of a plucked property of the objects within an array of objects example filter filter an array to the values that match a regular expression, a specific value, or non null value example filterby filter an array of objects to those that contain a property or deeply nested property whose values match a regular expression, a specific value, or non null value example numeric transformations round adjust a number rounding or flooring it example floor adjust a number flooring it example ceil adjust a number ceiling it example absolute value compute the absolute value of a number example less than check if the first number is less than the second example less than or equal check if the first number is less than or equal to the second example greater than check if the first number is greater than the second example greater than or equal check if the first number is greater than or equal to the second example random generate a random number between inclusive lower and upper bounds example object transformations remove remove a property on an object example is equal perform a deep comparison between two values to determine if they are equivalent example has by check if an object contains a property or deeply nested property example $objecthasby({ key 1 }, “key”) => true pick create an object composed of the picked properties example pluck by extract the value of a property or deeply nested property of an object example string transformations strip remove all whitespace (tabs, spaces, and newlines) from both the left and right side of text spaces in between words will not be removed example uuid v4 generate a v4 universally unique identifier (uuid) example hash compute that hash of a value example pad pad a string on the left and right sides if it's shorter than length padding characters are truncated if they can't be evenly divided by length example pad start pad a string on the left side if it's shorter than length padding characters are truncated if they can't be evenly divided by length example pad end pad a string on the right side if it's shorter than length padding characters are truncated if they can't be evenly divided by length example $stringpadend(“abc”, 5,”h”) => “abchh” repeat repeat a string n times example camel case convert a string to camel case example capitalize convert the first character of a string to upper case and the remaining to lower case example starts with check if a string starts with another example ends with check if a string ends with another example eval expression parse and evaluate a string containing literal json or a jsonata expression example value transformations is array check if value is an array example is string check if value is a string example is null or undefined check if value is null or undefined example is object check if a value is an object example from xml parse an xml string example from yaml parse a yaml string example from csv parse a csv string example to xml serialize a value to xml example to yaml serialize a value to yaml example to csv serialize a value to csv example