Added Data Tranformations

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:
  1. 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. 
  2. 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. 
  3. Added ReplaceNullTransformation 
  4. Added date and time transformations
    • Date String, gives the date from datetime value.
    • Year, gives the year from datetimevalue.
    • Start of Year, gives the first day of the year.
    • End of Year, gives the last day of the year.
    • Month, give the month number of the year.
    • Month Name, give the name of the month represented by the datetime value.
    • Start of Month, gives the first day of the month.
    • End of Month, gives the last day of the month.
    • Day, gives the day from the datetime value.
    • Day of Week,  gives the day of the week of the datetime value.
    • Day of Year, gives the day of the year represented by the datetime value.
    • Quarter, gives which quarter the date falls in.
    • Start of Quarter, gives the first date of the quarter.
    • End of Quarter, gives the last date of the quarter.
    • Time, gives the time part from the datetime value.
    • Hour, gives the hour from the datetime value.
    • Minute, gives the minute from datetime value.
    • Second, gives the seconds from the datetime value. 
  5. Added number transformations for external data  
    • Round allows you to round the numbers in the column up to a given number of decimal places.
    • Round Up rounds the numbers in the column up to the nearest whole number.
    • Round Down rounds the numbers in the column down to the nearest whole number.
    • Absolute Value returns the absolute value of the numbers in the column.
    • Cube returns the cube of the numbers.
    • Square returns the square of the numbers.
    • Square Root returns the square root of the numbers.
    • Is Even returns TRUE if the values in the column are even.
    • Is Odd returns TRUE if the values in the column are odd.
    • Sign returns 1 if the values in the column are positive, -1 if they are negative, and 0 otherwise.  
    • Logarithm
      • Natural returns the natural logarithm
      • Base-10 returns the base-10 logarithm.

Comments

Popular posts from this blog

Fixup changes in patches using fixup

Import ODF with data transformations