Creating Date

[Anonymous]

Hi All,

DISTCODE	CRNT_STCK PRODCODE	CalDate
600984	11340015	31/07/2012
600984	11340015	31/08/2012
600984	11340025	31/07/2012
600984	11340025	31/08/2012

for every distcode and its product , I want to create a Caldate till today.

Eg:

Discode   Prod          CadDate

600984    11340015   31/7/2012

600984    11340015   31/8/2012

600984    11340015   30/9/2012

600984    11340015   31/10/2012

Same for the Other Prod code.

Likewise , I ahve many Distcode and Multiple products.

Please Help

[jagannalla]

Hello,

You are trying to say that for each distcode and product you need caldate.

what is the start date for each distcode and product?

If possible please share your sample source data what you have.

Cheers!!

Jagan

[Anonymous]

DISTCODE	CRNT_STCK PRODCODE	CalDate
600984	11340015	31/07/2012
600984	11340015	31/08/2012
600984	11340025	31/07/2012
600984	11340025	31/08/2012
600984	11340156	31/07/2012
600984	11340156	31/08/2012
600984	11340157	31/07/2012
600984	11340157	31/08/2012
600984	11340214	31/07/2012
600984	11340214	31/08/2012
600984	11450190	31/07/2012
600984	11450190	31/08/2012
600984	12015250	31/07/2012
600984	12015250	31/08/2012
600984	12049301	31/07/2012
600984	12049301	31/08/2012
600984	12051784	31/07/2012
600984	12051784	31/08/2012
600984	12081203	31/07/2012
600984	12081203	31/08/2012
600984	12146624	31/07/2012
600984	12146624	31/08/2012
600984	12150438	31/07/2012
600984	12150438	31/08/2012
600984	12152461	31/07/2012
600984	12152461	31/08/2012
600984	12160802	31/07/2012
600984	12160802	31/08/2012
600984	12161728	31/07/2012
600984	12161728	31/08/2012
600984	12167438	31/07/2012
600984	12167438	31/08/2012
600984	12178140	31/07/2012
600984	12178140	31/08/2012

there are many Distcode with Such Cases.

[jagannalla]

I'm getting little bit confuse. Do you have 3 or 2 columns in your source file?

I thought that you have only 2 columns i.e. distcode and product.  Ok whatever it is if you have 3 columns then what you need output according to your source file data you mention in the above post.

What is the input you have now?

What is the expected output you need?

Cheers!!

Jagan

[Anonymous]

Input is :

600984	11340015	31/07/2012
600984	11340015	31/08/2012

Output should be

Discode   Prod          CadDate

600984    11340015   31/7/2012

600984    11340015   31/8/2012

600984    11340015   30/9/2012

600984    11340015   31/10/2012

for DistCode 600984    and  Prodcode 11340015