Results 1 to 6 of 6

Thread: Data Cleansing

  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a number of duplicate entries in a flat file which thanks to Hans I have now isolated. For example, I have 2 entries: name: Fred date of birth: 23 sep, 1969, address: anytown, one with say order 1: ice cream, order 2: bananas and the next with order 1: grapes, order 2: cream. These are in a flat file. What may be available to get these broke out so I only have one line for fred and his address, date of birth, then four lines of orders?


    Many thanks, Darren.

  2. #2
    4 Star Lounger
    Join Date
    Feb 2008
    Location
    United Kingdom
    Posts
    490
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I would have thought you would have gone for 2 related tables. The fiirst being peoples names, ages, address etc, and 1 table being for orders. You would need a mainform where you could enter all the persons details and a subform accepting the order details. Might be wrong, but thats the way I would do it.

  3. #3
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='ZOR' post='773081' date='30-Apr-2009 16:08']I would have thought you would have gone for 2 related tables. The fiirst being peoples names, ages, address etc, and 1 table being for orders. You would need a mainform where you could enter all the persons details and a subform accepting the order details. Might be wrong, but thats the way I would do it.[/quote]


    Thanks for this Zor, I am up to speed with your suggestiont. What I am saying is that the data is already in one file (I ahve inherited from as spread sheet) and I need a way of sorting it into one to many tables without having to manually trawl through.

    Thanks again, Darren.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    NormalizeDenormalize on Roger's Access Library shows how to do this using VBA, but the code will have to be customized for your situation.

  5. #5
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='773148' date='30-Apr-2009 20:36']NormalizeDenormalize on Roger's Access Library shows how to do this using VBA, but the code will have to be customized for your situation.[/quote]


    This is very good Hans

    Thank you

  6. #6
    4 Star Lounger
    Join Date
    Feb 2008
    Location
    United Kingdom
    Posts
    490
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks also from me Hans, I always wondered if there was a way to do that, I had always slogged it through the long way. Regards

Posting Permissions

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