One of the primary aims of this project was to add more data transformations. Here is a list of commits which helps us achieve these goals: Added text transformations for external data Uppercase , which sets all text in the selected columns to upper case. Lowercase , which sets all text in the selected columns to lower case. Capitalize Each Word , which makes all words in the selected column start with a capital letter and sets all subsequent letters in a word to lower case. Trim , which removes any leading or trailing whitespace characters from text. Added aggregate functions for external data Sum , which returns the sum of values in the column. Average , which returns the average of values in the column. Min , which returns the minimum of the values in the column. Max , which returns the maximum of the values in the column. Added ReplaceNullTransformation Added date and time transformations Date String, gives the date from datetime value . Year, g
Comments
Post a Comment