4 Replies Latest reply: Nov 22, 2012 6:41 AM by erika gupta RSS

    Creating Date

    erika gupta

      Hi All,

       

      DISTCODECRNT_STCK PRODCODECalDate
      6009841134001531/07/2012
      6009841134001531/08/2012
      6009841134002531/07/2012
      6009841134002531/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

        • Re: Creating Date
          Jagan Nalla

          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

            • Re: Creating Date
              erika gupta
              DISTCODECRNT_STCK PRODCODECalDate
              6009841134001531/07/2012
              6009841134001531/08/2012
              6009841134002531/07/2012
              6009841134002531/08/2012
              6009841134015631/07/2012
              6009841134015631/08/2012
              6009841134015731/07/2012
              6009841134015731/08/2012
              6009841134021431/07/2012
              6009841134021431/08/2012
              6009841145019031/07/2012
              6009841145019031/08/2012
              6009841201525031/07/2012
              6009841201525031/08/2012
              6009841204930131/07/2012
              6009841204930131/08/2012
              6009841205178431/07/2012
              6009841205178431/08/2012
              6009841208120331/07/2012
              6009841208120331/08/2012
              6009841214662431/07/2012
              6009841214662431/08/2012
              6009841215043831/07/2012
              6009841215043831/08/2012
              6009841215246131/07/2012
              6009841215246131/08/2012
              6009841216080231/07/2012
              6009841216080231/08/2012
              6009841216172831/07/2012
              6009841216172831/08/2012
              6009841216743831/07/2012
              6009841216743831/08/2012
              6009841217814031/07/2012
              6009841217814031/08/2012

               

              there are many Distcode with Such Cases.

                • Re: Creating Date
                  Jagan Nalla

                  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

                    • Re: Creating Date
                      erika gupta

                      Input is :

                      6009841134001531/07/2012
                      6009841134001531/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