### 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:

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,**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.- 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

## Post a Comment