I have a file where customer's terms changed on a specific date to a specific value. I would like this value to populate for every day until the next change.
Customer 12345 was changed to term A on 1/1/2015.
Customer 12345 was changed to term B on 2/5/2015.
Customer 12345 was changed to term C on 3/13/2015.
I would like a record created everyday for customer 12345 for the entire year. However from 1/1/2015 - 2/4/2014 customer 12345 should show a record everyday with term A. f
or 2/5/2015 - 3/12/2015 customer 12345 should show arecord every day with term B. from 3/13/2015 customer 12345 should show term C every day for the remainder of the year.
The columns I want would be customer, term, MMDDYYYY.
If I have 1 customer, I will have 365 records. If I have two customers, I will have 730 records, etc.