Calculate New column from exising columns
Posted: Fri Oct 01, 2010 9:18 pm
Hi,
I have a source file with columns productname,saletype,start date. Based on these columns I have to calculate end date for the corresponding records.
If the product is only one record,the end date should be 1-9-9999. Else teh end date is one day previous than the next record's start date.
Below is the example:
Product Name SaleType StartDate EndDate
ABC XYZ 1-2-2009 2-4-2010
DEF MNO 3-4-2010 1-9-9999
ABC XYZ 3-4-2010 1-9-9999
Please suggest me what stage can i use in this scenario to achieve end date calculation.
Thank You.
I have a source file with columns productname,saletype,start date. Based on these columns I have to calculate end date for the corresponding records.
If the product is only one record,the end date should be 1-9-9999. Else teh end date is one day previous than the next record's start date.
Below is the example:
Product Name SaleType StartDate EndDate
ABC XYZ 1-2-2009 2-4-2010
DEF MNO 3-4-2010 1-9-9999
ABC XYZ 3-4-2010 1-9-9999
Please suggest me what stage can i use in this scenario to achieve end date calculation.
Thank You.