Transform Text
In Concat column, StoreRef and RefCode are concatenated using CONCAT() function.
In Prod column, Product and ProdName columns are concatinated using CONCAT() funcion.
In Trim column, Reference column is trimmed using TRIM() function.
In Substitute column, - is sunbstituted by ; in reference column using SUBSTITUTE() function
In Sub column, Nail is substituted by Box of Nail in ProdName column using SUBSTITUTE() function
Len column is the length of ProdName column using LEN() function
Left column returns the left number in Prod column using LEFT() function
Right column returns the right side letters of Prod column using RIGHT() and LEN() functions.
Mid column returns middle letters of Reference column using MID() function.
Transform Date
Subtract Date column is date difference between the next row and the current row using normal subtraction
Datediff column is date difference between the next row and the current row using DATEDIFF() function
Year and Month columns are year and month of each row using YEAR() and MONTH() functions
eomonth column is end day of the month of each row using EOMONTH() function
Weekday column is the weekday number of each row using WEEKDAY() function
Day of Week and the column next to it are weekday names (abbreviated and full name) using TEXT() function to convert date to weekday name.
