2 Replies Latest reply: Feb 14, 2014 9:25 PM by Nirmal Raj RSS

    Index keys.

    David Young

      Here is my load statement. I want to normalize the data with a primary index key. 


      Load AccountNumber,

      AccountNamr

      FiscalYearStartDate

      BillStartDate

      from

      account.qvd;


      From there I want to show:


      AccountNumber 1

      AccountName - XYZ

      BillStartDate - 1/1/2013

      FiscalYearStartDate - 7/1/2012

      Month(FiscalYearStartDate) as Month - 7

      Month Index 1 since 7/1/2012 is the FiscalYearStartDate


      AccountNumber 2

      AccountName - ABC

      BillStartDate - 2/1/2013

      FiscalYearStartDate - 8/1/2012

      Month(FiscalYearStartDate) as Month - 8

      Month Index 1 since 8/1/2012 is the FiscalYearStartDate


      Does this make since?  Can this be done.


      David