Skip to main content
Question

Merge single year mdb database to 10 years mdb database

  • April 30, 2020
  • 2 replies
  • 19 views
A

Dear friends,

Please help me to merge two databases in single MDB, merge MDB file for winter 2019-2020 to winters 2009-2020 mdb database. I tried few options and it did not help much.

Also, I want to setup the system in task schedule.

 

Thank you.

 

Abzal

    This post is closed to further activity.
    It may be an old question, an answered question, an implemented idea, or a notification-only post.
    Please check post dates before relying on any information in a question or answer.
    For follow-up or related questions, please post a new question or idea.
    If there is a genuine update to be made, please contact us and request that the post is reopened.

    2 replies

    redgeographics
    Celebrity
    Forum|alt.badge.img+59
    • redgeographicsCelebrity
    • Celebrity
    • 3700 replies
    • May 1, 2020

    Can you give us a little bit more background?

    Do you want separate tables per winter? Or just one big one?

    What have you tried so far and why isn't it what you need?

    FME rocks! \m/
    A
    • atyergal
    • Author
    • 1 reply
    • May 4, 2020

    Dear Friends,

    Two mdb files, one mdb file is consisting of data for 2019-2020 and second mdb file has data for period 2009-2019. In result two databases should be merged. Merging process can consider also adding new features (classes) if created during the observations. I need one single database.

    I have tried using database joiner transformer, however it did not give in result merged database as data were not added for winter 2019-2020 in single database 2009-2020.

    Will try to watch more video online and gain experience, however if you have a better idea please share with me.

    Thank you.

    @redgeographics

    Regards,

    Abzal

     

    Community Stats

    32,076
    Posts
    121,794
    Replies
    39,702
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.