Theresa2000

Discussions

ETL: SQL Set column type
Is there a way to set the column type of while you are creating the column in mysql? I have a column that I am creating based on a date (Min Cust Svc Start) and a comparison to another date (1/1/2015). I want "Min Cust Svc Start 15" to be a datetype column; however, it is defaulting to text. I know I can change it in alter…
ETL: Calcs based on date ranges
I am using Magic ETL to load data. My data has columns for customer, month, product and revenue. I have created calculated columns in the ETL for the customers start month. I am trying to create a column that calculates the maximum monthly revenue for a customer within the first 3 months of their start date; this is…