Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jul 2006
    Posts
    96
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Normalising Data (2003)

    Hi, a few weeks back you kindly helped me out with normalising data into year-end periods. for the purposes of another exercise I need to split the same data down, period by period, over a period of some 20 years. The data coming to me comes by way of extract which unfortunately does not give me the periods I need on the "horizontal" or "vertical" to allow me to normalise in the way you showed me, but has years going down the vertical, and periods going across. Therefore we have Asset, Year, Period 1, Period 2 Period 3 etc. when what i want is:

    Asset 200101 Value
    Asset 200002 Value
    Asset 200003 Value

    Have looked at the module you helped me with last time, which worked a dream, but can't get my head around what to do now that I have additional fields to consider on the vertical. I'm attaching the tables and the original module to show you what I mean.

    Can you help??

    Cheers.

    Ina Real Fix

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Normalising Data (2003)

    Please explain which table you want converted - there are two in your database.

  3. #3
    Star Lounger
    Join Date
    Jul 2006
    Posts
    96
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Normalising Data (2003)

    HistoryTest shows the data I want to normalise as above.

    Thanks Hans.

    Ina

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Normalising Data (2003)

    See the attached version, and note the comment in the loop.

  5. #5
    Star Lounger
    Join Date
    Jul 2006
    Posts
    96
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Normalising Data (2003)

    Thanks Hans will look it over.

    Ina

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •