6 Replies Latest reply on May 22, 2012 4:47 PM by philmodjunk

    Restructure challenge

    GuyStevens

      Title

      Restructure challenge

      Post

      I'm helping someone on this forum ( http://forums.filemaker.com/posts/8a189b941e?start=11&stop=20#195705 )

      And he has the problem that his table structure is very wrong.

      I think it's maybe a very Excell type of mindset that was used, anyway. It's all filled in and reports need to be made. But the data is in a horrible form to do it.

      Is there anyone that has any experience or ideas how best to go about transforming this:

      Relationships

      Fields

      Into this:

      Excell

      So it can be imported in a simple line items kind of way, linked to the students.
      If this could be done directly into filemaker that would be great as well.

      The problem is that the Category name comes from the table name. But that could be set as a global field, no problem there.
      The other problem is all of the fields. Every "item" is not a new record, but a different field. And the name of the item, is the fieldname.
      And you always have two fields, First the amount, then a divide factor.

      Anyway, converting from horizontal to vertical. Anyone any ideas?

      Can this be scripted without having to manually set every field?
      Or will this be a case of exporting every table and then manually rearranging everything?